查询至少有一门课与学号为“1001”的同学所学相同的同学的学号和姓名

select S#,Sname from Student,SC where Student.S#=SC.S# and C# in select C# from SC where S#=’1001’;