|
| 20210 在 2024/11/6 14:44:41
说到： |
|
| |
请查询个人平均成绩最高的同学姓名，平均成绩以及与最低平均成绩的差值并用“平均差”表示 |
|
|
| 发言人：2021014635 |
发言时间：2024/11/7 14:46:11 |
select distinct top 1 sname,avg(grade) as 最高平均成绩,(select distinct top 1 avg(grade) from sc group by sno order by avg(grade) desc)- (select distinct top 1 avg(grade) from sc group by sno order by avg(grade)) as 平均差 from sc,student where sc.sno=student.sno group by sname order by avg(grade) desc
|
| 发言人：2021014625 |
发言时间：2024/11/7 14:45:45 |
select distinct top 1 sname,avg(grade) as 最高平均成绩,(select distinct top 1 avg(grade) from sc group by sno order by avg(grade) desc)- (select distinct top 1 avg(grade) from sc group by sno order by avg(grade)) as 平均差 from sc,student where sc.sno=student.sno group by sname order by avg(grade) desc
|
|
