题解 | 统计员工薪资扣除比例
统计员工薪资扣除比例
https://www.nowcoder.com/practice/08db6f0135664ca598b579f8d53dc486
select a.staff_id,a.staff_name,concat(round(100*b.dock_salary/b.normal_salary,1),'%') as dock_ratio from (select staff_id,staff_name,department from staff_tb where department='dep1') a join salary_tb b on a.staff_id=b.staff_id order by dock_ratio desc
文远知行公司福利 588人发布