题解 | #最差是第几名(二)#
最差是第几名(二)
https://www.nowcoder.com/practice/165d88474d434597bcd2af8bf72b24f1
select t.grade
from(
select *
,SUM(number)OVER(ORDER BY grade)as zx
,SUM(number)OVER(ORDER BY grade desc)as nx
,SUM(number)over()as sm
from class_grade
)t
WHERE t.zx>=0.5*t.sm
and t.nx>=0.5*t.sm
order by t.grade
