题解 | %返回余数
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select job,case when c%2=0 then round(c/2) else round((c+1)/2) end start,case when c%2=0 then round(c/2+1) else round((c+1)/2) end end from(select job,count(job) c from grade group by job) t order by job
查看12道真题和解析
