题解 | 考试分数(四)
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
with count_temp as ( select job,count(*) as count from grade group by job ) select job,round(count/2) as start, case when count%2 != 0 then round(count/2) else round(count/2)+1 end as end from count_temp order by job;
三奇智元机器人科技有限公司公司福利 70人发布