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