数据库系统概论第四版第三章课堂练习题.pptVIP

* 第三章 SQL语言习题 * 1、查询选修3门以上课程的学生总成绩(不统计不 及格的课程),并要求按总成绩的降序排列。 正确的SELECT语句是 。 B SELECT SNO,SUM(SCORE) FROM Score WHERE SCORE=60 GROUP BY SNO ORDER BY 2 DESC HAVING COUNT(*)=3 SELECT SNO,SUM(SCORE) FROM Score WHERE SCORE=60 ORDER BY 2 DESC GROUP BY SNO HAVING COUNT(*)=3 SELECT SNO,SUM(SCORE) FROM Score WHERE SCORE=60 HAVING COUNT(*)=3 GROUP BY SNO ORDER BY 2 DESC SELECT SNO,SUM(SCORE) FROM Score WHERE SCORE=60 GROUP BY SNO HAVING COUNT(*)=3 ORDER BY 2 DESC A B D C * 2、查询选修课程“3-105”的学生中成绩最高的 学生学号。正确的SELECT语句是 。 D SELECT SNO FROM Score WH