View Code
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