sql3.50——3.56



3.50

select student.sno ,sname,ssex,sage,sdept,cno,grade

from student,sc

where student.sno=sc.sno;

3.51

select sc.sno,sname

from sc,student

where sc.cno='2' and sc.grade>'90'

    and sc.sno=student.sno;

3.52

select first.cno,second.cpno

from course first,course second

where first.cpno=second.cpno;

3.53

select student.sno,sname,ssex,sage,sdept,cno,grade

from student left outer join sc on (student.sno=sc.sno);

select student.sno,sname,ssex,sage,sdept,cno,grade

from sc rightouter join student on (student.sno=sc.sno);

3.54

select student.sno,sname,cname,grade

from student,sc,course

where student.sno=sc.sno and sc.cno=course.cno;

3.55

select sno,sname,sdept

from student

where sdept in

    (select sdept

    from student

    where sname='刘晨'

    );

select s1.sno,s1.sname,s1.sdept

from student s1,student s2

where s1.sdept=s2.sdept and s2.sname='刘晨';

3.56

select student.sno,sname

from student,sc,course

where course.cname = '信息系统'

    and student.sno=sc.sno

    and sc.cno=course.cno;

select sno,sname

from student

where sno in

    (select sno

    from course

    where cnoin

       (select cno

       from course

       where cname='信息系统'

       )

    );