题解 | #考试分数(四)#
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select
job,
floor(if(count(*)%2=0, count(*)/2, (count(*)+1)/2)) as start,
floor(if(count(*)%2=0, count(*)/2+1, (count(*)+1)/2)) as end
from
grade
group by
job
order by
job
查看12道真题和解析