题解 | #平均工资#

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'))

将查询条件全部放入到where语句中

一个有两个大的判断条件

1、在职 to_date = '9999-01-01'

2、工资大于在职最低工资且小于在职最高工资 (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'))