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