sql3.35——3.49



3.35

select *

from course

where cname like'DB\_%i__'ESCAPE

3.36

select sno,cno

from sc

where grade is NUll;

3.37

select sno,cno

from sc

where grade is not null;

3.38

select sname

from student

where sdept='cs' andsage<20;

select sname,ssex

from student

where sdept='cs' orsdept='ma' or sdept='is';

3.39

select sno,grade

from sc

where cno='3'

order by gradedesc;

3.40

select *

from student

order by sdept,sage desc;

3.41

select COUNT(*)

from student;

3.42

select COUNT(distinct sno)

from sc;

3.43

select AVG(all grade)

from sc

where cno='1';

3.44

select max(grade)

from sc

where cno='1';

3.45

select sum(ccredit)

from sc,course

where sno='201215012' and sc.cno=course.cno;

3.46

select cno,COUNT(sno)

from sc

group by cno;

3.47

select sno

from sc

group by sno

having COUNT(*)>3;

3.48

select sno,AVG(grade)

from sc

group by sno

having avg(grade)>=90;

3.49

select student.*,sc.*

from student,sc

where student.sno=sc.sno;

select *

from student,sc

where student.sno=sc.sno;