题解 | 最差是第几名(二)
最差是第几名(二)
https://www.nowcoder.com/practice/165d88474d434597bcd2af8bf72b24f1
with t as (
select grade, number,
(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
)
select grade
from t
where sum1>=total/2 and sum2>=total/2
order by grade
OPPO公司福利 1081人发布
