学生s、课程c、选课sc
#查询出选了全部课程的学生
select s.sid ,s.name
FROM s WHERE s.sid IN(
SELECT sc.`cid` FROM sc GROUP BY sc.sid HAVING COUNT(cid) = (SELECT COUNT(*) FROM c)
);
#查询出选课在2门以上的学生信息
select s.sid ,s.name
FROM s WHERE s.sid IN(
SELECT sc.`cid` FROM sc GROUP BY sc.sid HAVING COUNT(cid) > 1 FROM c)
);