题解 | #平均工资#

我的方法：

select avg(salary) 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')

法二：

SELECT (SUM(salary) - MAX(salary) - MIN(salary)) / (COUNT(1)-2) avg_salary 
FROM salaries where to_date = '9999-01-01';