题解 | #作答试卷得分大于过80的人的用户等级分布#
作答试卷得分大于过80的人的用户等级分布
http://www.nowcoder.com/practice/5bc77e3a3c374ad6a92798f0ead4c744
SELECT level, COUNT(*) AS level_cnt
FROM user_info a JOIN exam_record b USING (uid)
LEFT JOIN examination_info c USING (exam_id)
WHERE tag = 'SQL'
AND score > 80
GROUP BY level
ORDER BY level_cnt DESC;
查看9道真题和解析
