题解 | 考试分数(四)

select b.job, round((case when b.nu%2!=0 then nu_1/2 when b.nu%2=0 then b.nu/2 end)) start, round((case when b.nu%2!=0 then nu_1/2 when nu%2=0 then nu/2+1 end)) end
from 
(select job, count(job) nu,count(job)+1 nu_1
from 
    (select *
     from grade
     order by job,score asc
    ) a
group by job
) b
order by job