Leetcode力扣 MySQL数据库 1468 计算税后工资

最新推荐文章于 2024-05-31 10:26:40 发布

ziko-1101

最新推荐文章于 2024-05-31 10:26:40 发布

阅读量128

点赞数

分类专栏： Leetcode MySQL数据库（VIP）题目及解答文章标签：数据库 mysql leetcode

本文链接：https://blog.csdn.net/m0_46458212/article/details/127675072

版权

1468 计算税后工资

SQL架构

Create table If Not Exists Salaries_1468 (company_id int, employee_id int, employee_name varchar(13), salary int);
Truncate table Salaries_1468;
insert into Salaries_1468 (company_id, employee_id, employee_name, salary) values ('1', '1', 'Tony', '2000');
insert into Salaries_1468 (company_id, employee_id, employee_name, salary) values ('1', '2', 'Pronub', '21300');
insert into Salaries_1468 (company_id, employee_id, employee_name, salary) values ('1', '3', 'Tyrrox', '10800');
insert into Salaries_1468 (company_id, employee_id, employee_name, salary) values ('2', '1', 'Pam', '300');
insert into Salaries_1468 (company_id, employee_id, employee_name, salary) values ('2', '7', 'Bassem', '450');
insert into Salaries_1468 (company_id, employee_id, employee_na