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