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

剔除最大值和最小值，直接用max和min函数就可以