题解 | #试卷发布当天作答人数和平均分#
试卷发布当天作答人数和平均分
https://www.nowcoder.com/practice/5b58e89556dc4153a79d8cf8c08ba499
select
exam_id,
count(distinct ui.uid) as uv,--人数
round(avg(score), 1) as avg_score--均分
from
exam_record er
inner join user_info ui using(uid)
inner join examination_info ei using(exam_id)
where
tag = 'SQL'--sql类型
and level > 5--大于五
and date_format(submit_time, '%Y%m%d') = date_format(release_time, '%Y%m%d') --当天
group by
exam_id
order by
uv desc,
avg_score
腾讯云智研发开奖36人在聊
