SELECT sta.staff_id, staff_name, CONCAT(ROUND(100 * dock_salary / normal_salary, 1), '%') AS dock_ratio FROM staff_tb sta JOIN salary_tb sal ON sta.staff_id = sal.staff_id WHERE department = 'dep1' ORDER BY dock_ratio DESC