select sid,sname from Student
where sid in(
select sid from SC
where cid in(
select cid from SC where sid ='0000000001'
)
group by sid
having count(*)=(select count(*)from SC where sid='0000000001')
);
Student表:
SC表:
Teacher表:
Course表: