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

SELECT grade
FROM
(SELECT *
      ,SUM(NUMBER) OVER(ORDER BY grade) AS up_rank
      ,SUM(NUMBER) OVER(ORDER BY grade DESC) AS down_rank
      ,SUM(NUMBER) OVER() AS total
FROM class_grade
ORDER BY grade
) AS t1
WHERE up_rank>=total/2 AND down_rank>=total/2