题解 | #SQL类别高难度试卷得分的截断平均值#
SQL类别高难度试卷得分的截断平均值
http://www.nowcoder.com/practice/a690f76a718242fd80757115d305be45
select f.tag,f.difficulty, round((sum(e.score)-max(e.score)-min(e.score))/(count(e.score)-2),1) as clip_avg_score from exam_record e inner join examination_info f on e.exam_id=f.exam_id where f.tag='SQL' and f.difficulty='hard';
腾讯公司福利 832人发布
投递腾讯等公司6个岗位 >
