题解 | #考试分数(四)#
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select
job
, round(count(score)*1.0/2) as start
, case when count(score)%2 = 1 then round(count(score)*1.0/2,0) else round(count(score)*1.0/2+1) end as end
from
grade
group by
job
order by
job