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