题解 | #某乎问答高质量的回答中用户属于各级别的数量#
某乎问答高质量的回答中用户属于各级别的数量
http://www.nowcoder.com/practice/69c85db3e59245efb7cee51996fe2273
SELECT
case
when author_level<=2 then "1-2级"
when author_level>=3 and author_level<=4 then "3-4级"
else "5-6级" end as level_cnt,count(*)as num
from author_tb inner join answer_tb using(author_id)
where char_len>=100
group by level_cnt
order by num desc
投递OPPO等公司6个岗位 >