题解 | #考试分数(四)#
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select job,case when count(id)%2=0 then round(count(id)/2,0) when count(id)%2=1 then round((count(id)+1)/2,0) end as start, case when count(id)%2=0 then round((count(id)/2)+1,0) when count(id)%2=1 then round((count(id)+1)/2,0) end as end from grade group by job order by job asc
投递字节跳动等公司7个岗位 >
腾讯泡池子969人在聊