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' ORDER BY dock_ratio DESC