我试图从我的表中创建一个视图。当我从1个表中创建这样的视图时，效果很好：

CREATE VIEW v2 AS
    SELECT section_id, section_name,  count(*) AS num, count(*) as num1
    FROM section_of_science
    GROUP BY section_id;

select * from v2;

但当我尝试从两个表创建视图时，它不起作用：

CREATE VIEW v3 AS
    SELECT section_of_science.section_id, section_of_science. section_name,
           scientific_areas.areas_name,  count(*) AS num, count(*) as num1
    FROM section_of_science,
         scientific_areas
    GROUP BY section_id;

select * from v3;

我得到一个错误：
select列表的表达式#3不在group by子句中，它包含未聚合列“lab3.scientific#areas.areas#name”，该列在功能上不依赖于group by子句中的列；这与sql\u mode=only\u full\u group by不兼容
我做错什么了？
如果你需要更多的信息，请告诉我。