sql script

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