#[1] 查询选修“0002”号课程的学生的成绩最高分
SELECT MAX(Grade)
FROM score JOIN student
ON score.Sno=student.Sno
WHERE score.Cno='0002'
#[2] 统计参加“0001”号课程考试的学生人数
SELECT COUNT(*)
FROM score JOIN student
ON score.Sno=student.Sno
WHERE score.Cno='0001'
#[3] 计算“0003”号课程中所有参加过考试的学生平均分
SELECT AVG(Grade)
FROM score JOIN student
ON score.Sno=student.Sno
WHERE score.Cno='0003'
#[4] 查询选修了3门课以上[包括3门]的学生姓名
SELECT Sname,COUNT(*)
FROM score JOIN student
ON score.Sno=student.Sno
GROUP BY Sname
HAVING COUNT(*)>=3
#[5] 统计各个课程号及相应的选课人数
SELECT Cno,COUNT(*)
FROM score
GROUP BY Cno
#[6] 统计没有参加考试的学生学号和姓名
SELECT student.Sno,Sname
FROM score JOIN student
ON score.Sno=student.Sno
WHERE Grade IS NULL
#[7] 查询选修了所有课程的学生学号和姓名
SELECT student.Sno,student.Sname
FROM student JOIN score
ON student.Sno=score.Sno
GROUP BY student.Sno
HAVING COUNT(*)=5
#[8] 统计选修人数在3人以上[包括3人]的课程号和课程名
SELECT course.Cno,course.Cname
FROM score JOIN course
ON score.Cno=course
MySQL——homework02
最新推荐文章于 2023-04-25 18:26:37 发布
本文详细探讨了MySQL数据库在作业中的应用,涵盖了SQL查询、表操作和事务处理等方面,旨在帮助读者深入理解MySQL的基本概念和实践技巧。
摘要由CSDN通过智能技术生成