计算机应用研究所

20210 在 2024/10/30 14:14:11 说到：
	查询和刘晨选课一样的,个人平均成绩大于85分的同学姓名和平均成绩

这条发言的回复：

发言人：2021014635

发言时间：2024/10/30 14:15:08

select sname,avg(grade) from student,sc where student.sno=sc.sno and sc.sno in (select distinct sno from sc scx where not exists (select*from sc scy where scy.sno in (select student.sno from student where sname='刘晨') and not exists (select*from sc scz where scz.sno=scx.sno and scz.cno=scy.cno))) and sname <>'刘晨' group by sname having avg(grade)>85

TEL:-******** Email:yyh@zwu.edu.cn