题解 | 中位数的问题转化成排序问题

select grade
from (select grade,sum(number)over(order by grade) a,sum(number)over(order by grade desc) b from class_grade) t
where a>=(select sum(number)/2 from class_grade) and b>=(select sum(number)/2 from class_grade)
order by grade