题解 | #考试分数(四)#
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
SELECT job,(CASE WHEN (COUNT(job)+1) % 2 =0 THEN TRUNCATE((COUNT(job)+1) / 2,0) ELSE TRUNCATE((COUNT(job)+1)/2 -0.5,0) END) AS start,( CASE WHEN (COUNT(job)+1) % 2 =0 THEN TRUNCATE((COUNT(job)+1) / 2,0) ELSE TRUNCATE((COUNT(job)+1)/2 + 0.5,0) END) AS end FROM grade GROUP BY job ORDER BY job;
）