题解 | 统计员工薪资扣除比例
统计员工薪资扣除比例
https://www.nowcoder.com/practice/08db6f0135664ca598b579f8d53dc486
with t1 as(
select *
from staff_tb
where department = 'dep1'
)
select
s.staff_id as staff_id,
staff_name,
concat(round(dock_salary/normal_salary*100,1),'%') as dock_ratio
from t1
left join salary_tb s
on t1.staff_id=s.staff_id
order by dock_ratio desc
