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

select staff_tb.staff_id
,staff_name
,concat(round(dock_salary/normal_salary*100,1),'%') dock_ratio
from staff_tb
join salary_tb
on staff_tb.staff_id = salary_tb.staff_id
where department = 'dep1'
order by dock_ratio desc