0 56 163923 select classcountCASE WHEN avgs=80 THEN 1 ELSE 0 ENDcount from select sumscorecountcourse as avgsfrom tb_score inner join tb_student usingid group by id group by class LIMIT 0 1000 Error
错误代码1248表示每个派生表必须有自己的别名。在你的查询中,派生表是你使用的子查询,它需要一个别名。
请在子查询后面添加一个别名,以解决这个错误。例如:
SELECT class, count(CASE WHEN avgs>=80 THEN 1 ELSE 0 END)/count(*) FROM (SELECT *, sum(score)/count(course) as 'avgs' FROM tb_score INNER JOIN tb_student USING(id) GROUP BY id) AS subquery GROUP BY class LIMIT 0, 1000
原文地址: https://www.cveoy.top/t/topic/iGxq 著作权归作者所有。请勿转载和采集!