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