...包含学生表,课程表,学生选课表3个表,分别是:
发布网友
共2个回答
热心网友
您好，您这样：
--1
select Sname,Sage from Student where Sage<(select Sage from Student where Sno='某一学生') and Sdept='数学系'
--2
select Sname from Student where Sno in (select Sno from SC)
--3
select Sname from Student where Sno in (select Sno from SC group by Sno having count(*)=(select count(*) from Course ))
热心网友
其实很简单，我建议你一个一个问，不然回答也很烦的
