题解 | #SQL类别高难度试卷得分的截断平均值#
select tag,
difficulty,
round(avg(score),1) as clip_avg_score
from examination_info
left join exam_record
on examination_info.exam_id = exam_record.exam_id
where tag = 'SQL' and difficulty = 'hard'and
score not in (
(select max(score) from exam_record),
(select min(score) from exam_record)
)
投递华为HUAWEI等公司9个岗位