SELECT a.tag,a.difficulty,ROUND((SUM(b.score)-MAX(b.score)-Min(b.score))/(COUNT(b.score)-2),1) AS clip_avg_score
FROM examination_info a JOIN exam_record b 
ON a.exam_id=b.exam_id
WHERE a.tag='SQL' AND a.difficulty='hard';