题解 | #某乎问答高质量的回答中用户属于各级别的数量#
某乎问答高质量的回答中用户属于各级别的数量
https://www.nowcoder.com/practice/69c85db3e59245efb7cee51996fe2273
select case when author_level between 1 and 2 then '1-2级' when author_level between 3 and 4 then '3-4级' else '5-6级' end as level_cut, count(author_id)as num from author_tb join answer_tb using(author_id) where char_len>=100 group by level_cut order by num desc
投递中国邮政储蓄银行等公司10个岗位
查看10道真题和解析