题解 | #试卷发布当天作答人数和平均分#
作答试卷得分大于过80的人的用户等级分布
http://www.nowcoder.com/practice/5bc77e3a3c374ad6a92798f0ead4c744
select
ui.level,
count(distinct ui.uid) as level_cnt
from user_info as ui,exam_record as er,examination_info as ei
where
ui.uid = er.uid
and er.exam_id = ei.exam_id
and ei.tag = 'SQL'
and er.score > 80
group by ui.level
order by level_cnt desc,ui.level desc
美的集团公司福利 442人发布
投递戴尔等公司6个岗位 >