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

Question

表

代码以及报错
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

Answer 1

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