题解 | 最差是第几名(二)

select 
    grade 
from
(
    select
        *,
        min(diff) over(order by diff) min_diff
    from
        (
            select
                grade,
                abs((sum(number) over(order by grade))
                    - (sum(number) over(order by grade desc))) diff
            from 
                class_grade
            order by grade
        ) t1 
) t2
where diff = min_diff
order by grade