ASELECT S.学号,姓名,平均成绩FROM S,SCWHERE S.学号=SC.学号
GROUP BY S.学号HAVING COUNT(*)>5 0RDER BY平均成绩DESC
BSELECT学号,姓名,AVG(成绩)FROM S,SC
WHERE S.学号=SC.学号AND COUNT(*)>5
GROUP BY学号0RDER BY 3 DESC
CSELECT S.学号,姓名,AVG(成绩)平均成绩FROM S,SC
WHERE S.学号=SC.学号AND COUNT(*)>5
GROUP BY S.学号ORDER BY平均成绩DESC
DSELECT S.学号,姓名,AVG(成绩)平均成绩FROM S,SC
WHERE S.学号=SC.学号
GROUP BY S.学号HAVING COUNT(*)>5 0RDER BY 3 DESC