select avg(salary) from salaries 
where to_date='9999-01-01' and 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'
)