题解 | #考试分数(四)#
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
with tmp as (
select job, min(r) as i, max(r) as m from (select job, score, row_number() over(partition by job order by score desc) as r from grade) as tb
group by job
)
select job, if((i+m) % 2 =0, round((i+m)/2), floor((i+m)/2)), if((i+m) % 2 =0, round((i+m)/2), ceil((i+m)/2)) from tmp
order by job
round和floor和ceil都可以取整，floor是地板，向下取整，ceil是天花板，细胞壁，向上取整
京东二面185人在聊
你cet6就cet6，cet4就cet4，你写个cet证书等是什么意思。专业技能快赶上项目行数，你做的这2个项目哪里能提现你有这么多技能呢
查看6道真题和解析