题解 | #最差是第几名(二)#
最差是第几名(二)
http://www.nowcoder.com/practice/165d88474d434597bcd2af8bf72b24f1
select grade
from (
select *,(
select sum(number)
from class_grade
where grade<=c.grade
) t_rank
from class_grade c
inner join (
select sum(number) total
from class_grade
) c2
on 1=1
) t
where (t_rank-number+1<=if(total&1,floor(total/2)+1,floor(total/2)) and t_rank>=if(total&1,floor(total/2)+1,floor(total/2)))
or (t_rank-number+1<=floor(total/2)+1 and t_rank>=floor(total/2)+1)
order by grade;
辅导员肯定不能同意，不然你出事了，他要承担责任。但是，脚和脑子都长在你自己身上，使用它还需要向辅导员报告么？
辅导员必须按流程拒绝你，然后你拿出成年人的态度，做自己的选择。