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