select job, floor(count(id)/2+0.5) as 'start' ceiling(count(id)/2+0.5) as 'end' from grade group by job order by job;
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务