SELECT student.* FROM student WHERE student.SId not in (SELECT sc.SId FROM sc GROUP BY sc.SId HAVING COUNT(sc.SId) = 3)
SELECT student.* FROM student WHERE student.SId IN (SELECT DISTINCT sc.SId FROM sc WHERE sc.CId IN (SELECT sc.CId FROM sc WHERE sc.SId = 01) AND sc.SId != 01)
若有收获，就点个赞吧
0 人点赞
