题解 | #考试分数(四)#

select
    job 
    , round(count(score)*1.0/2) as start
    , case when count(score)%2 = 1 then round(count(score)*1.0/2,0) else round(count(score)*1.0/2+1) 		end as end
from 
    grade
group by 
    job
order by 
    job