课程表结构如下SC(sno, cno, cname, grade),其中列cno和sno的数据类型均为varchar(20),cname为nvarchar(20),grade数据类型为smallint,查询每位学生所有课程的平均分和,对应的SQL语句可以是( )。
A.
select sno, AVG(grade) from SC group by sno;
B.
select cno, AVG(grade) from SC group by cno;
C.
select sno, SUM(grade) from SC group by sno;
D.
select sno, min(grade) from SC group by sno;