select tag,difficulty,round((sum(e.score)-max(e.score)-min(e.score))/ (count(e.score)-2),1) clip_avg_score 
from examination_info f
join exam_record e
on f.exam_id=e.exam_id
group by tag,difficulty
having tag = 'SQL'
and  difficulty='hard'