A.SELECTS.学号,姓名,AVG(成绩)平均成绩FROMS,SC;WHERES.学号=SC.学号;GROUPBYS.学号,姓名HAVINGCOUNT(*)>=5ORDERBY3DESC
B.SELECTS.学号,姓名,AVG(成绩)FROMS,SC;WHERES.学号=SC.学号ANDCOUNT(*)>=5;GROUPBY学号,姓名ORDERBY3DESC
C.SELECTS.学号,姓名,AVG(成绩)平均成绩FROMS,SC;WHERES.学号=SC.学号ANDCOUNT(*)>=5;GROUPBYS.学号,姓名ORDERBY平均成绩DESC
D.SELECTS.学号,姓名,平均成绩FROMS,SC;WHERES.学号=SC.学号;GROUPBYS.学号,姓名HAVINGCOUNT(*)>=50RDERBY平均成绩DESC