这个错误是由于你在COUNT函数中使用了CASE语句的问题。在COUNT函数中,只能使用列名或者通配符(*)来统计行数,不能使用其他表达式。

你可以将CASE语句放在SELECT子句中,然后在外层的COUNT函数中使用列名或者通配符(*)来统计行数。修改后的SQL语句如下:

SELECT COUNT(CASE WHEN avg_num >= 80 THEN 1 ELSE NULL END) / COUNT(*) FROM ( SELECT id, SUM(score) / COUNT(course) as avg_num FROM tb_score INNER JOIN tb_student USING(id) GROUP BY id ) subquery;

0	55	163800	select classcountCASE WHEN sumscorecountcourse=80 as avg_num THEN avg_num ELSE 0 ENDcount from tb_score inner join tb_student usingid group by id	Error Code 1064 You have an error in your

原文地址: https://www.cveoy.top/t/topic/iGw8 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录