select (sum(salary)-min(salary)-max(salary))/(count(salary)-2) as avg_salary from salaries where to_date='9999-01-01';