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

select job,if(mod(count(id),2)=0,count(id) div 2,(count(id) div 2)+1) start,if(mod(count(id),2)=0,(count(id) div 2)+1,(count(id) div 2)+1) end
from grade
group by job
order by job;