题解 | #平均工资#

# 法1：
select (sum(salary)-max(salary)-min(salary))/(count(*)-2)
from salaries
where to_date = '9999-01-01';
# 法2
select avg(salary)
from salaries
where 
salary not in (select max(salary) from salaries where to_date = '9999-01-01') and 
salary not in (select min(salary) from salaries where to_date = '9999-01-01') and
to_date='9999-01-01'