希冀平台2-4:查找排除当前最大、最小salary之后的员工的平均工资avg_salary。 CREATE TABLE salaries
( emp_no
int(11) NOT NULL,
SELECT AVG(salary) AS avg_salary
FROM salaries
WHERE salary <>(SELECT MAX(salary)FROM salaries)
AND salary <>(SELECT MIN(salary)FROM salaries)
and to_date='9999-01-01';