题解 | #平均工资#请教下各位这个无输出的原因是在哪里哇
平均工资
https://www.nowcoder.com/practice/95078e5e1fba4438b85d9f11240bc591
DELETE FROM salaries
WHERE salary IN(
SELECT * FROM(SELECT MAX(salary) FROM salaries
WHERE to_date='9999-01-01') AS max_salary);
DELETE FROM salaries
WHERE salary IN(
SELECT * FROM(SELECT MIN(salary) FROM salaries
WHERE to_date='9999-01-01') AS min_salary);
SELECT AVG(salary) FROM salaries WHERE to_date='9999-01-01'