题解 | #平均工资#

select
    avg(salary) as avg_salary
from
    (
        select
            *,
            row_number() over (
                order by
                    salary
            ) r1,
            row_number() over (
                order by
                    salary desc
            ) r2
        from
            salaries
        where
            to_date = '9999-01-01'
    ) as a
where
    a.r1 != 1
    and a.r2 != 1;