题解 | #平均工资#

错误
select avg(salary) as avg_salary from salaries where to_date ='9999-01-01'  and salary not in (select max(salary)，min(salary)  from salaries where to_date='9999-01-01') 


正确-分开写
select avg(salary) as avg_salary from salaries where to_date ='9999-01-01'  and 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') ;