题解 | #考试分数(四)#
考试分数(四)
http://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
case when 还是用的太少了
select job,
(case when count(1)%2=1 then round((count(1)+1)/2) else round(count(1)/2) end) start,
(case when count(1)%2=1 then round((count(1)+1)/2) else round(count(1)/2)+1 end) end
from grade
group by job
order by job; 
