题解 | 统计员工薪资扣除比例
select st.staff_id as staff_id,
st.staff_name as staff_name,
concat (round(dock_salary / normal_salary * 100, 1), '%') as dock_ratio
from
staff_tb st,
salary_tb sa
where
st.staff_id = sa.staff_id
and st.department = 'dep1'
order by
(dock_salary / normal_salary) desc
查看14道真题和解析
