题解 | 统计员工薪资扣除比例
统计员工薪资扣除比例
https://www.nowcoder.com/practice/08db6f0135664ca598b579f8d53dc486
SELECT staff.staff_id, staff_name, CONCAT(ROUND(dock_salary/normal_salary*100, 1), "%") AS dock_ratio FROM staff_tb staff JOIN salary_tb salary ON staff.staff_id = salary.staff_id WHERE department = "dep1" ORDER BY dock_ratio DESC