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

查看8道真题和解析