1.查询和学号为108的同学同年出生的所有学生的Sno、Sname和Sbirthday列。
select s.sno,s.sname,s.sbirthday from student s where to_char(s.sbirthday,'yyyy')= (select to_char(t.sbirthday,'yyyy')
from STUDENT t where t.sno='108')
2.查询选修某课程的同学人数多于5人的教师姓名
select t.tname from teacher t where t.tno= (select c.tno from course c where c.cno=(select cno from SCORE s
group by cno having count (cno)>5))
3.查询95033班和95031班全体学生的记录。
SELECT
*
FROM
student s
JOIN score sc ON s.sno = sc.sno
JOIN course c ON c.cno = sc.cno
JOIN teacher t ON t.tno = c.tno
WHERE
s.sclass = '95033'
OR s.sclass = '95031'
4.查询存在有85分以上成绩的课程Cno.
select distinct t.cno from SCORE t where t.degree>=85
注释:distinct 去重
5.查询出“计算机系“教师所教课程的成绩表。
SELECT s.degree FROM score s WHERE s.cno in (SELECT c.cno FROM course c WHERE c.tno in (SELECT t.tno FROM teacher t WHERE t.depart='计算机系'))
注释:in 的用法