查询平均成绩小于70分的学生学号和平均成绩 A: SELECT Sno, AVG(grade) FROM SC GROUPBYSno B: SELECT Sno, AVG(grade) FROM SC GROUPBYSno HAVINGAVG(grade)<70; C: SELECT Sno, grade FROM SC GROUPBYSno HAVINGAVG(grade)<70;
查询平均成绩小于70分的学生学号和平均成绩 A: SELECT Sno, AVG(grade) FROM SC GROUPBYSno B: SELECT Sno, AVG(grade) FROM SC GROUPBYSno HAVINGAVG(grade)<70; C: SELECT Sno, grade FROM SC GROUPBYSno HAVINGAVG(grade)<70;
1