假设成绩表(score)存储了同学的(sno),科目和科目成绩(score),下列查询平均成绩大于60分的同学的和平均成绩数据的sql语句,正确的是
A.
select sno, avg(score) from score group by sno having avg(score) >60;
B.
select sno, avg(score) from score group by sno having score >60;
C.
select sno from score group by sno having score >60;
D.
select sno, avg(score) from having score >60;