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