SQL作业（下）

38 select s.sname,to_char(sysdate,'yyyy')-to_char(s.sbirthday,'yyyy') from student s where s.sbirthday is not null

39 select max(to_char(s.sbirthday,'mm/dd')),min(to_char(s.sbirthday,'mm/dd')) from student s

40 select s.* from student s where s.sbirthday is not null order by s.class,to_char(sysdate,'yyyy')

41 select c.tno,c.cno from course c inner join teacher t on t.tno=c.tno where t.tsex='男'

42 select s.sno,s.cno,s.degree from score s where degree=(select max(degree) from score)

43 select s.sname from student s where s.ssex in (select ssex from student where ssex='男')

44 select s.sname from student s where s.ssex in (select ssex from student where ssex='男') and s.class in
(select class from student where sname='李军')

45 select s.* from score s inner join course c on c.cno=s.cno inner join student ss on ss.sno=s.sno
where ss.ssex='男' and c.cname='计算机导论'

转载于:https://www.cnblogs.com/kaililikai/p/5972092.html