13问答网 > 统计考试平均成绩大于等于80分的学生的姓名、考试的课程号、考试成绩和平均成绩，……

统计考试平均成绩大于等于80分的学生的姓名、考试的课程号、考试成绩和平均成绩，……

2025-02-24 06:34:42

推荐回答（2个）

回答1：

SELECT Sname,Cno,Grade,平均成绩
FROM Student JOIN SC ON Student.Sno=SC.Sno
JOIN (SELECT Sno,AVG(Grade) 平均成绩 FROM SC GROUP BY Sno HAVING AVG(Grade)>=80) A ON Student.Sno=A.Sno

回答2：

select Sname,Cno,Grade,(select avg(Grade)
from SC sc2 where sc2.Sno=sc1.Sno) as avgGrade
from Student,SC sc1
where sc1.Sno=Student.Sno and sc1.Sno in(select Sno
from SC sc3
group by Sno
having avg(Grade)>=80)
order by avgGrade desc;