题解 | 平均工资
平均工资
https://www.nowcoder.com/practice/95078e5e1fba4438b85d9f11240bc591
SELECT ROUND(AVG(S.salary),0) AS avg_salary
FROM salaries S
WHERE S.to_date ='9999-01-01'
AND S.salary NOT IN (
SELECT MAX(S.salary) AS MAX_SALARY
FROM salaries S
WHERE S.to_date ='9999-01-01'
UNION
SELECT MIN(S.salary) AS MIN_SALARY
FROM salaries S
WHERE S.to_date ='9999-01-01'
)
