题解 | #某乎问答高质量的回答中用户属于各级别的数量#
某乎问答高质量的回答中用户属于各级别的数量
https://www.nowcoder.com/practice/69c85db3e59245efb7cee51996fe2273
with t1 as(
select author_id
from answer_tb
where char_len>=100
),
t3 as(
select t1.author_id,author_level from t1
left join author_tb t2 on t1.author_id= t2.author_id
),
t4 as(
select (case when author_level=5 or author_level=6 then '5-6级'
when author_level=3 or author_level=4 then '3-4级'
when author_level=1 or author_level=2 then '1-2级' end) level_cut
from t3
)
select level_cut , count(*) num
from t4
group by level_cut
order by num desc
再次感谢佬的面经，完美押中了sql和算法题
