sql script
select (sum(salary)-max(salary)-min(salary))/(count(*)-2) as avg_salary from salaries where to_date='9999-01-01' group by to_date
select (sum(salary)-max(salary)-min(salary))/(count(*)-2) as avg_salary from salaries where to_date='9999-01-01' group by to_date