sql1 从student表中查询每个院系有多少人2 从score表中查询sc 每个科目的最高分3 查询李四的考试科目和考试成绩4 查询所有学生的信息和考试信息5 计算每个学生的总成绩6 计算每个考试科目的平均成绩7 查询计算机成绩低于95的学生信息8 将计算机考试成绩按从高到低进行排序9 查询姓张或姓王的学生的姓名、院系和考试科目及成绩10 查询都是湖南的学生的姓名、年龄、院系和考试科目及成绩
- SELECT department, COUNT(*) FROM student GROUP BY department
- SELECT course, MAX(score) FROM score GROUP BY course
- SELECT course, score FROM score JOIN student ON score.sid = student.sid WHERE student.name = '李四'
- SELECT * FROM student JOIN score ON student.sid = score.sid
- SELECT sid, SUM(score) AS total_score FROM score GROUP BY sid
- SELECT course, AVG(score) AS avg_score FROM score GROUP BY course
- SELECT * FROM student JOIN score ON student.sid = score.sid WHERE course = '计算机' AND score < 95
- SELECT * FROM score WHERE course = '计算机' ORDER BY score DESC
- SELECT student.name, student.department, score.course, score.score FROM student JOIN score ON student.sid = score.sid WHERE student.name LIKE '张%' OR student.name LIKE '王%'
- SELECT student.name, student.age, student.department, score.course, score.score FROM student JOIN score ON student.sid = score.sid WHERE student.province = '湖南
原文地址: https://www.cveoy.top/t/topic/g0ZD 著作权归作者所有。请勿转载和采集!