数据库

SELECT snum,sname,ssex,sbirth,dnum
FROM s
--where snum='S006'
WHERE dnum='d02'

SELECT score,snum
from sc
where score>=60 and score<=85

SELECT snum,sname
from s
where sname like '王_'

SELECT cnum,score*1.5
from sc
where cnum='c01'and score is not null

select distinct snum
from sc

select snum,score
from sc
where cnum='c01'
order by score asc

select s.snum,s.sname,sc.cnum,sc.score
from s,sc

select distinct s.sname,c.cname,c.cfreq
from s,c

select  s.snum,s.sname,sc.score
from s,sc
where cnum='c02' and score>=85