题解 | #某乎问答高质量的回答中用户属于各级别的数量#
某乎问答高质量的回答中用户属于各级别的数量
https://www.nowcoder.com/practice/69c85db3e59245efb7cee51996fe2273
with t1 as(
select author_id, issue_id,
(case when author_level in (1,2) then '1-2级'
when author_level in (3,4) then '3-4级'
when author_level in (5,6) then '5-6级'
else 0 end) as level_cut
from answer_tb
join author_tb using(author_id)
where char_len>100
)
select level_cut,
count(issue_id) as num
from t1
group by level_cut
