数据库SQL语言习题求助！

来源：百度知道 编辑：UC知道 时间：2024/06/05 22:08:20
学生数据库中有三个基本表（关系）
S（Sno， Sname, Age,Sex, DEPT）
C（Cno, Cname, Teacher）
SC（Sno, Cno, Grade）试用SQL语言完成以下操作
(1)检索学生姓名及其所选修课程的课程号和成绩。
(2)检索选修4门以上课程的学生总成绩（不统计不及格的课程），并要求按总成绩降序排列出来。
(3)查询选修了“计算机”课程的女学生姓名；

select s.sname,sc.Cno,sc.grade from sc inner join s on s.sno=sc.sno

select s.sname,sc.Cno,sum(sc.grade) from sc inner join s on s.sno=sc.sno where sc.grade>=60 group by s.sname,sc.Cno having count(*)>=4 order by sum(sc.grade) desc

select s.sname,sc.Cno,sc.grade from sc inner join s on s.sno=sc.sno inner join c on c.cno=sc.cno
where c.cname='计算机' and s.sex='女'

1.select s.sname,c.cno,sc.grade from s,c,sc where s.sno=sc.sno and c.cno=sc.cno
2.
select a.zf from (select sum(grade) as zf from sc where grade>=60 group by sno having count(*)>=4) a order by zf desc
3.
select sname from s where sno in
(selet sno from sc where cno=(select cno from c where cname='计算机')) and Sex='女'

select s.Sname,c.Cbane,Sc.Grade
from Sc inner join S on Sc.Sno=S.Sno
inner join C on SC.Cno=C.Cno

select Sno,Cno,sum(Grade) from Sc
order by Grade
group by sno,con
having c