题解 | #考试分数(四)#
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
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;
