select staff_id
,staff_name
,concat(round(dock_salary/normal_salary*100,1),'%') as dock_ratio
from staff_tb join salary_tb using(staff_id)
where department = 'dep1'
order by dock_ratio desc