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