MorningSss_的博客

代码段：SELECT score.SId AS 学号,student.Sname AS 姓名FROM scoreLEFT JOIN student ON score.SId=student.SIdWHERE score.SId IN (SELECT score.SIdFROM scoreGROUP BY score.SIdHAVING COUNT(score.CId)=2)GROUP BY score.SId,student.Sname表：...

代码段：SELECT student.SId AS 学号,student.Sname AS 姓名,student.Sage AS 年龄,student.Ssex AS 性别FROM studentWHERE student.Sname LIKE '%风%'

代码段：SELECT COUNT(*) AS '「李」姓老师的数量'FROM teacherWHERE Tname LIKE '李%'SELECT COUNT(*) AS '「李」姓老师的数量'FROM teacherWHERE Tname LIKE '李%'teacher

代码段：SELECT student.SId AS 学号,student.Sname AS 姓名,student.Sage AS 年龄,student.Ssex AS 性别FROM studentWHERE student.SId<>01 AND student.SId IN (SELECT score.SIdFROM scoreWHERE score.CId IN(SELECT score.CIdFROM scoreWHERE score.SId=01) AND NOT

表：coursescorestudentteacher

表：coursescore

表：course

表：course

表：course

表： course查询思路：1.