还是同样的表 如下报错怎么办

表

img

img

img

img

img

img


代码以及报错
select 学号,课程号 as 不及格课程,avg(成绩) as 平均成绩
from chengji
where 成绩<80 -- 指定查询条件
GROUP BY 学号 -- 根据一个或多个列对结果集进行分组。
HAVING COUNT(不及格课程)<=2

1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yuanshen.chengji.课程号' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
时间: 0s

like后面的要加引号，SELECT * FROM student where 姓名 LIKE '可%'

你的数据库版本是5.7之前的吧
执行这个语句就行了:
SET GLOBAL sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

img