select e.tag as tag ,e.difficulty as difficulty ,round((sum(r.score)-max(r.score)-min(r.score))/(count(r.score)-2),1) as clip_avg_score from examination_info e join exam_record r on e.exam_id=r.exam_id where e.tag="SQL" and e.difficulty="hard"