题解 | 统计员工薪资扣除比例

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