题解 | #试卷发布当天作答人数和平均分#
试卷发布当天作答人数和平均分
http://www.nowcoder.com/practice/5b58e89556dc4153a79d8cf8c08ba499
SELECT e.exam_id,count(distinct r.uid) as uv,round(avg(r.score),1) as avg_score
from exam_record r
join user_info u on r.uid=u.uid and u.level>5
join examination_info e on e.exam_id=r.exam_id and e.tag='SQL'
where date(start_time) in (SELECT date(release_time) from examination_info where tag='SQL')
group by e.exam_id
ORDER by uv desc,avg_score asc