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');