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

select sid,sname from Student
where sid in(
    select distinct sid from SC
    where cid in(
        select cid from SC
        where sid ='0000000001'
        )
    );

Student表：

SC表：

Teacher表:

Course表：