从学生成绩表SC中查询平均成绩大于60分的同学的和平均成绩的正确语句为:
A.
select sno,avg(score) as sscore from sc group by sno having avg(score) >60
B.
select sno,avg(score) as sscore from sc group by sno where avg(score) >60
C.
select sno,avg(score) as sscore from sc where avg(score) >60
D.
select sno,avg(score) as sscore from sc having avg(score) >60