题解 | #平均工资#

使用union

select avg(salary) from salaries where salary not in(
select max(salary) from salaries where to_date="9999-01-01"
union 
select min(salary) from salaries where to_date="9999-01-01"
)
and to_date="9999-01-01"