select avg(salary) avg_salary
from salaries
where to_date='9999-01-01' and salary not in(
(select min(salary)
from salaries
where to_date='9999-01-01'),
(SELECT max(salary)
from salaries
where to_date='9999-01-01')
)
group by to_date;