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

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

2025-02-26 09:50:29

推荐回答（1个）

回答1：

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 '王%'

有错的地方请指点！