题解 | #某乎问答高质量的回答中用户属于各级别的数量#
某乎问答高质量的回答中用户属于各级别的数量
https://www.nowcoder.com/practice/69c85db3e59245efb7cee51996fe2273
应用case when
select
case
when au.author_level in (1,2) then '1-2级'
when au.author_level in (3,4) then '3-4级'
else '5-6级'
end as level_cut,
count(an.issue_id) co
from answer_tb an
join author_tb au
on an.author_id = au.author_id
where an.char_len >= 100
group by(level_cut)
order by(co) desc
查看14道真题和解析
