MySQL1 设学生课程数据库中有三张表：学生表SS#SNAMEAGESEX学习表SCS#C#GRADE课程表CC#CNAME其中S#、C#、SNAME、AGE、SEX、GRADE、CNAME分别表示学号、课程号、姓名、年龄、性别、成绩和课程名。用SQL语句表达下列操作每小题4分共20分1 检索选修课程名称为MATHS的学生的学号与姓名2 检索至少学习了课程号为C1和C2的学生的学号3 检索年龄在

SELECT S#, SNAME FROM S WHERE S# IN (SELECT S# FROM SC WHERE C# = 'MATHS')
SELECT S# FROM SC WHERE C# IN ('C1', 'C2') GROUP BY S# HAVING COUNT(DISTINCT C#) >= 2
SELECT S#, SNAME, AGE FROM S WHERE AGE BETWEEN 18 AND 20 AND SEX = 'F'
SELECT S#, AVG(GRADE) AS AVG_GRADE FROM SC GROUP BY S# HAVING AVG(GRADE) > 80
SELECT SNAME FROM S WHERE S# IN (SELECT S# FROM SC GROUP BY S# HAVING COUNT(DISTINCT C#) >= 3)

原文地址: https://www.cveoy.top/t/topic/iavU 著作权归作者所有。请勿转载和采集!