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