|
| 20200 在 2023/4/8 10:01:17
说到： |
|
| |
查询计算机系个人选课平均成绩大于80分的，个人总成绩超过所有管理系学生个人总成绩的学生姓名及总成绩有多少个 |
|
|
| 发言人：2020014433 |
发言时间：2023/4/8 10:08:28 |
select sname,sum(grade) as 总成绩
from student,sc where student.sno=sc.sno
and sdept='计算机系' group by sc.sno,sname having avg(grade)>80
and sum(grade)>all(select sum(grade) from student,sc where student.sno=sc.sno and sdept='管理系' group by student.sno)
|
| 发言人：2020014439 |
发言时间：2023/4/8 10:02:22 |
select distinct tname,tglass,tsdept,cname
from course,teacher
where teacher.tno=course.tno and tglass='副教授'and tsdept='计算机系'
|
|
