SQL 75) 查询各个岗位分数升序排列之后的中位数位置的范围

方法）找出中位数位置

SELECT job,
    FLOOR((COUNT(score)+1)/2 )AS start, 
    FLOOR((COUNT(score)+2)/2) AS end
FROM grade
GROUP BY job
ORDER BY job;