题解 | #考试分数(二)#
考试分数(四)
http://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
SELECT job,
CASE WHEN COUNT(job)%2=0 THEN TRUNCATE(COUNT(job)/2,0)
ELSE TRUNCATE(FLOOR(COUNT(job)/2)+1,0)
END start
,
CASE WHEN COUNT(job)%2=0 THEN TRUNCATE(COUNT(job)/2,0)+1
ELSE TRUNCATE(FLOOR(COUNT(job)/2)+1,0)
END end
FROM grade
GROUP BY job
ORDER BY job ASC
投递科大讯飞等公司6个岗位