A.SELECT s.学号,姓名,平均成绩 FROM s JOIN sc ON s.学号 = sc.学号GROUP BY s.学号 HANVING COUNT(*)>=5 ORDER BY 平均成绩 DESC
B.SELECT 学号,姓名,AVG(成绩) 平均成绩 FROM s JOIN sc ON s.学号 = sc.学号WHERE COUNT(*)>=5 GROUP BY 学号 ORDER BY 平均成绩 DESC
C.SELECT s.学号,姓名,AVG(成绩) 平均成绩 FROM s CROSS JOIN sc WHERE s.学号 = sc.学号 AND COUNT(*) >= 5GROUP BY s.学号 ORDER BY 平均成绩 DESC
D.SELECT s.学号,姓名,AVG(成绩) 平均成绩 FROM s JOIN sc ON s.学号 = sc.学号GROUP BY s.学号,姓名 HANVING COUNT(*)>=5 ORDER BY 平均成绩 DESC
正确答案：SELECT s.学号,姓名,AVG(成绩) 平均成绩 FROM s JOIN sc ON s.学号 = sc.学号GROUP BY s.学号,姓名 HANVING COUNT(*)>=5 ORDER BY 平均成绩 DESC

点击查看答案进入小程序搜题