题解 | #最差是第几名(二)#
最差是第几名(二)
https://www.nowcoder.com/practice/165d88474d434597bcd2af8bf72b24f1
select
grade
from(
select
grade,
(select sum(number) from class_grade) as total,
sum(number) over (order by grade) as sum1,
sum(number) over (order by grade desc) as sum2
from class_grade
) as cg
where sum1 >= total/2 and sum2 >= total/2
order by grade
查看3道真题和解析