查询平均成绩良好 也就是≥80分的考生人数 查询语句就可以写成（）。
已帮助 人
查询平均成绩良好，也就是≥80分的考生人数，查询语句就可以写成（）。
A.WITH avgach (eeid,avgachieve) AS (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;
B.WITH avgach (eeid,avgachieve) (SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;
C.SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid )AS avgach (eeid,avgachieve) WHERE avgachieve>=80;
D.SELECT COUNT
热搜：卷杀和收分的区别
回答
共1条回复-
SELECT COUNT(*) FROM ( SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid ) AS avgach (eeid,avgachieve) WHERE avgachieve>=80;;SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid ) avgach (eeid,avgachieve) WHERE avgachieve>=80;