select avg(salary) as avg_salary
from salaries
where salary not in(
select max(salary)
from salaries
where to_date='9999-01-01'
union
select min(salary)
from salaries
where to_date='9999-01-01'
) and to_date='9999-01-01';