基于“学生.选课.课程”数据库中的如下三个关系:
- A学生基本信息:S(S#,SNAME,SEX,AGE)
- B选课信息:SC(S#,C#,GRADE)
- C课程信息:C(C#,CNAME,TEACHER)
- D若要求“查询选修了5门以上课程的学生的学生号”,正确的SQL语句是( )。
- EA)SELECT S# FROM SC ORDER BY S# WHERE COUNT(﹡)>5
- FB)SELECT S# FROM SC ORDER BY S# HAVING COUNT(﹡)>5
- GC)SELECT S# FROM SC GROUP BY S# WHERE COUNT(﹡)>5
- HD)SELECT S# FROM SC GROUP BY S# HAVING COUNT(﹡)>5