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

老衲一个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