题解 | #平均工资#

SELECT AVG(salary)
FROM salaries
WHERE to_date = '9999-01-01' AND
salary <> (SELECT MAX(salary) FROM salaries WHERE to_date = '9999-01-01') AND
salary <> (SELECT MIN(salary) FROM salaries WHERE to_date = '9999-01-01');