• 查询选修了全部课程的学生信息

SELECT * from Student WHERE SId IN (
	SELECT sid   from sc GROUP BY sid HAVING COUNT(cid) = (SELECT COUNT(*) FROM Course))

SQL 练习38