|
| 20200 在 2023/4/8 10:01:57
说到： |
|
| |
查询和刘晨选课一样的,个人平均成绩大于85分的同学姓名和平均成绩 |
|
|
| 发言人：2020014433 |
发言时间：2023/4/8 10:07:50 |
select sname,avg(grade) as 平均成绩 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
|
| 发言人：2020014439 |
发言时间：2023/4/8 10:02:38 |
select distinct tname,tglass,tsdept,cname
from course,teacher
where teacher.tno=course.tno and tglass='副教授'and tsdept='计算机系'
|
|
