10-15 查询选修某两门课程的学生 (10分)

检索出sc表中至少选修了’C001’与’C002’课程的学生学号。

select a.sno '学号' 
from (select * from sc where (cno = 'C001')) a 
inner join 
(select * from sc where (cno = 'C002')) b 
on a.sno = b.sno

`