SELECT 
    job,
    ceil((count(*))/2) AS "start", 
    ceil((count(*) + 1)/2) AS "end"
FROM grade
GROUP BY job
ORDER BY job;

ceil向上取数

floor向下取数

也可以用 floor((count(*)+1)/2) AS "start",

floor((count(*) + 2)/2) AS "end"