select staff_id,
staff_name,
dock_ratio
from (
    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'
) as t
order by dock_ratio desc