-
20200325 数据库连接查询面试题作业
2020-07-24 10:57#6 查询出语文最高分
SELECT Max(sc.score) from sc inner join course as c on sc.Cno=c.Cno and c.Cname='语文'
#8 查询语数外三门成绩的平均分
select c.Cname,avg(sc.score) from course as c inner join sc on c.Cno=sc.Cno
Group by c.Cname
#9 查询报名孤独求败老师课程的学生信息
select * from teacher as t inner join course as c
on t.Tno=c.Tno and t.Tname='孤独求败'
inner join sc on c.Cno=sc.Cno
