1.查询“刘阳”老师所授课程情况;
2.查询与“计算机”专业在同一学院的其他专业的学生情况;
3.查询没有选修'数据库“课程的学生情况;
4.查询选修了‘t1'老师所授全部课程的学生情况;
5.查询选修了全部课程的学生情况
1.SELECT *
FROM t,tc
where t.tno=tc.tno and tn='刘阳';
2.select *
FROM s
where dept in (SELECT dept
FROM s
WHERE maj ='计算机');
3.select *
from s
where sno not in(SELECT sno
FROM sc,c
WHERE sc.cno=c.cno and cn like '数据库系统');
4.SELECT *
FROM s
where not EXISTS(select *
FROM c
where tno='t1' and not EXISTS(SELECT *
from sc
where s.sno=sc.sno and sc.cno=tc.cno));
5.SELECT *
from s
where not EXISTS(select *
from c
where not EXISTS(SELECT *
from sc
where s.sno=sc.sno and sc.cno=c.cno));