select
    department,
    round(avg(normal_salary - dock_salary), 3) as avg_salary
from
    staff_tb st
    join salary_tb sa using (staff_id)
#实发薪资剔除
where
    normal_salary - dock_salary between 4000 and 30000
group by
    department
order by
    avg_salary desc