题解 | #SQL类别高难度试卷得分的截断平均值#
试卷发布当天作答人数和平均分
http://www.nowcoder.com/practice/5b58e89556dc4153a79d8cf8c08ba499
select
tag, difficulty, round(avg(score),1)
from exam_record
join examination_info
on exam_record.exam_id = examination_info.exam_id
where score != (select min(score) from exam_record)
and score != (select max(score) from exam_record)
and exam_record.exam_id = 9001
tag, difficulty, round(avg(score),1)
from exam_record
join examination_info
on exam_record.exam_id = examination_info.exam_id
where score != (select min(score) from exam_record)
and score != (select max(score) from exam_record)
and exam_record.exam_id = 9001
查看22道真题和解析
