下列SQL语句中,_____________可以在“学生-课程”数据库正确实现“查询选修并成绩良好3门以上课程的学生学号及其满足条件的课程门数”。
选项:
A:SELECT Sno,COUNT(*)FROM SCGROUP BY SnoHAVING Grade>=80 AND COUNT(*) >3;
B:SELECT Sno,COUNT(*)FROM SCWHERE Grade>=80GROUP BY SnoHAVING COUNT(*) >3;
C:SELECT Sno,COUNT(*)FROM SCGROUP BY SnoWHERE Grade>=80HAVING COUNT(*) >3;
D:SELECT Sno,COUNT(*)FROM SCGROUP BY SnoWHERE Grade>=80 AND HAVING COUNT(*) >3
发布时间:2024-05-07 19:21:05