题解 | #考试分数(四)#
考试分数(四)
http://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
【关键】关键是case when 函数的运用！
【代码如下】
select job,
case when count(score)%2=0 then floor(count(score)/2) else floor(count(score)/2)+1 end as start,
case when count(score)%2=0 then floor(count(score)/2)+1 else floor(count(score)/2)+1 end as end
from grade group by job
order by job
投递比特大陆等公司10个岗位
