老衲一个if+floor收了这题
select job, if(count(job)%2=0,floor(count(job)/2),floor(count(job)/2+1)) `start`, if(count(job)%2=0,floor(count(job)/2+1),floor(count(job)/2+1)) `end` from grade group by job order by job ASC
老衲一个if+floor收了这题
select job, if(count(job)%2=0,floor(count(job)/2),floor(count(job)/2+1)) `start`, if(count(job)%2=0,floor(count(job)/2+1),floor(count(job)/2+1)) `end` from grade group by job order by job ASC