×
多选题
116、以下几个班级的学员考试平均分进行统计,字段grade(分数),stuname(学生姓名),stuno(学生学号),一下SQL正确的有( )
A
select avg(grade) as s from score group by stuno
B
select stuno,avg(grade) as s from score group by stuno
C
select stuno,stuname,avg(grade) as s from score group by stuno
D
select stuno,stuname,avg(grade) as s from score group by stuno,stuname
答案解析
正确答案：ABD
相关知识点：
操作员账号权限：创建删除修改有
