查询选修课程在5门以上(含5门)的学生的、姓名和平均成绩,并按平均成绩降序排序,正确的命令是
A.
SELECT s.,姓名,平均成绩FROM student s,score sc WHERE s.=sc. GROUP BY s.HAVING COUNT(*)>=5 ORDER BY平均成绩DESC
B.
SELECT,姓名,AVG(成绩)FROM student s,score sc WHERE s.=sc.AND COUNT(*)>=5 GR0UP BYORDER BY 3 DESC
C.
SELECT s.,姓名,AVG(成绩)平均成绩FROM student s,score sc wHERE s.=sc.AND COUNT(*)>=5 GROUP BY s.ORDER BY平均成绩DESC
D.
SELECT s.,姓名,AVG(成绩)平均成绩FROM student s,score sc WHERE s.=sc. GROUP BY s.HAVING COUNT(*)>=5ORDER BY 3 DESC