题解 | #考试分数(四)#
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select a.job, ceil((a.count_)/2) start, ceil((a.count_+1)/2) end from (select job,count(*) count_ from grade group by job) a order by a.job
- 求中位数位置
- 利用特殊值带入验算
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select a.job, ceil((a.count_)/2) start, ceil((a.count_+1)/2) end from (select job,count(*) count_ from grade group by job) a order by a.job
相关推荐