题解 | #某乎问答高质量的回答中用户属于各级别的数量#
某乎问答高质量的回答中用户属于各级别的数量
https://www.nowcoder.com/practice/69c85db3e59245efb7cee51996fe2273
select
case
when A.author_level<=2 then '1-2级'
when A.author_level between 3 and 4 then '3-4级'
else '5-6级'
end as level_cut
,count(*) as num
from author_tb A
inner join answer_tb B
on A.author_id=B.author_id
where B.char_len>=100
group by level_cut
order by num desc;
查看14道真题和解析
感觉好强，工作肯定能找到