select s.id, (select (sum(x)- max(x)-min(x))/5 FROM (select 
unnest(array[score1,score2,score3,score4,score5,score6,score7])as x ))
from scores s;