题解 | #平均工资#
平均工资
http://www.nowcoder.com/practice/95078e5e1fba4438b85d9f11240bc591
用子查询选出salary的最大和最小值，然后限制salary不等于最大或最小值并且to_date='9999-01-01'，最后将salary取平均。
select avg(s.salary) from salaries as s,
(select max(salary) as Mx, min(salary) as Mn from salaries
where to_date = '9999-01-01' ) as temp
where s.salary <> temp.Mx and s.salary <> temp.Mn and s.to_date = '9999-01-01'
科大讯飞一面307人在聊