SQL 练习11

• 查询至少有一门课与学号为" 01 "的同学所学相同的同学的信息

SELECT * from Student WHERE SId in 
(SELECT SId from sc WHERE cid in (SELECT cid from sc WHERE sid='01'))