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

select
st.staff_id,
st.staff_name,
concat(cast((sl.dock_salary*100/sl.normal_salary) as decimal(5,1)),'%') as dock_ratio
from staff_tb st left join salary_tb sl
on st.staff_id=sl.staff_id
group by st.staff_id,st.staff_name,st.department,sl.dock_salary,sl.normal_salary
having st.department='dep1'
order by dock_ratio desc;