SELECT * from Student WHERE SId IN ( SELECT sid from sc GROUP BY sid HAVING COUNT(cid) = (SELECT COUNT(*) FROM Course))
SQL 练习38
原文：https://www.cnblogs.com/bangbangzoutianya/p/15168869.html
