select salary_tb.staff_id
, staff_name
, concat(round(dock_salary/normal_salary*100,1),'%') dock_ratio
from salary_tb
left join staff_tb
on salary_tb.staff_id = staff_tb.staff_id
where dock_salary > 0
and department = 'dep1'
order by 3 desc