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