题解 | #某乎问答高质量的回答中用户属于各级别的数量#
某乎问答高质量的回答中用户属于各级别的数量
https://www.nowcoder.com/practice/69c85db3e59245efb7cee51996fe2273
SELECT CASE WHEN t.author_level IN (5,6) THEN '5-6级'
WHEN t.author_level IN (3,4) THEN '3-4级'
WHEN t.author_level IN (1,2) THEN '1-2级'
END AS level_cut,
COUNT(s.issue_id) AS num
FROM answer_tb AS s LEFT JOIN author_tb AS t
ON s.author_id= t.author_id
WHERE s.char_len >= 100
GROUP BY level_cut
ORDER BY num DESC
;
查看30道真题和解析
投递快手等公司10个岗位
安克创新 Anker公司福利 782人发布