题解 | #试卷发布当天作答人数和平均分#
试卷发布当天作答人数和平均分
https://www.nowcoder.com/practice/5b58e89556dc4153a79d8cf8c08ba499
-- 试卷发布当天条件使用子查询即可
select exam_id,count(distinct uid) as uv,
round(avg(score),1) as avg_scorefrom exam_record
join user_info
using(uid)
where level > 5
and (exam_id,date(start_time)) in (select exam_id,date(release_time) from examination_info)
group by exam_id
order by uv desc,avg_score asc
查看12道真题和解析
投递京东等公司10个岗位