关系 Student,SC,Course,Teacher
Student(Snum,Sname,Ssex,Sage)
SC(Cnum,Cname,Tnum)
Course(Cnum,Cname,Tnum)
select * from Student
where Snum in
(select Snum from SC,Course where SC.Cnum=Course.Cnum
and (Cname in('数据结构','大学英语'))
group by Snum
having count(*)>=2)