sql3.35——3.49



3.35

select*

fromcourse

wherecname like'DB\_%i__'ESCAPE

3.36

selectsno,cno

fromsc

wheregrade is NUll;

3.37

selectsno,cno

fromsc

wheregrade is not null;

3.38

selectsname

fromstudent

wheresdept='cs'andsage<20;

selectsname,ssex

fromstudent

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

3.39

selectsno,grade

fromsc

wherecno='3'

orderby gradedesc;

3.40

select*

fromstudent

orderby sdept,sagedesc;

3.41

selectCOUNT(*)

fromstudent;

3.42

selectCOUNT(distinctsno)

fromsc;

3.43

selectAVG(all grade)

fromsc

wherecno='1';

3.44

selectmax(grade)

fromsc

wherecno='1';

3.45

selectsum(ccredit)

fromsc,course

wheresno='201215012'and sc.cno=course.cno;

3.46

selectcno,COUNT(sno)

fromsc

groupby cno;

3.47

selectsno

fromsc

groupby sno

havingCOUNT(*)>3;

3.48

selectsno,AVG(grade)

fromsc

groupby sno

havingavg(grade)>=90;

3.49

selectstudent.*,sc.*

fromstudent,sc

wherestudent.sno=sc.sno;

select*

fromstudent,sc

wherestudent.sno=sc.sno;