题解 | 统计员工薪资扣除比例
统计员工薪资扣除比例
https://www.nowcoder.com/practice/08db6f0135664ca598b579f8d53dc486
selectstaff_tb.staff_id,staff_tb.staff_name, concat(round((salary_tb.dock_salary/normal_salary)*100,1),'%') as dock_ratio from staff_tb join salary_tb on staff_tb.staff_id=salary_tb.staff_id where staff_tb.department='dep1' order by dock_ratio desc;
1.找到两表的连接条件字段；2.筛选出where 条件筛选出部门为 dep1 的员工；3.计算薪资扣除比例并格式化