题解 | 统计员工薪资扣除比例
统计员工薪资扣除比例
https://www.nowcoder.com/practice/08db6f0135664ca598b579f8d53dc486
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
