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