select department, round(avg(normal_salary-dock_salary),3) avg_salary
from staff_tb f 
join salary_tb s 
using(staff_id)
where (normal_salary-dock_salary) between 4000 and 30000
group by department
order by avg_salary desc;
这题就是先筛选后group了，用where