题解 | #某乎问答高质量的回答中用户属于各级别的数量#
某乎问答高质量的回答中用户属于各级别的数量
https://www.nowcoder.com/practice/69c85db3e59245efb7cee51996fe2273
select
level_cut
,count(char_len) num
from
(
select
case when author_level between 5 and 6 then '5-6级'
when author_level between 3 and 4 then '3-4级'
else '1-2级' end level_cut
,char_len
from answer_tb t1 left join author_tb t2
on t1.author_id = t2.author_id
where char_len >= 100
)table1
group by level_cut
order by num desc;
投递文远知行等公司10个岗位