设有一个学生-课程数据库，包括学生关系Student、课程关系C和选修关系SC.

1>select sno,sname from Student where sdept='IS'
2>select SNO,GRADE from SC where SNO=1
3>select SC.GRADE ,C.CName from SC , C where SC.SNO=990101 and SC.CNO=C.CNO
4>select Student.sname SC.SNO SC.CNO from Student inner join SC on Stuent.SNO=SC.SNO where SC.GRADE >95

5>select Student.sname ,SC.GRADE from Student inner join SC on Stuent.SNO=SC.SNO where SC.CNO=(select CNO from C where CNAME='ACCESS') order by SC.GREDE dec
6> select sno ,sname ,sdept from Student where sname like '王%'

有错的地方请指点！