列出总成绩超过200分的学生,要求列出、总成绩,按总成绩降序排序
A.
select sno 学号,sum(grade) 总成绩 from sc group by sno where sum(grade)>200 order by 2 asc
B.
select sno 学号,sum(grade) 总成绩 from sc group by sno having sum(grade)>200 order by 2 desc
C.
select sno 学号,sum(grade) 总成绩 from sc group by sno having sum(grade)>200 order by 2 asc
D.
select sno 学号,sum(grade) 总成绩 from sc group by sno where sum(grade)>200 order by 2 desc