15 这个数据库到底怎么做呀

Question

根据公式：应发合计=基本工资+职级工资+职级绩效，扣款合计=（应发合计-5000）*0.03，实发工资=应发合计-扣款合计，计算每位职工2021年5月份的工资，并使用使用INSERT INTO tbl_salary(各字段) SELECT语句将计算得到的工资 添加到tbl_salary表中。month字段的值为’2021-05-01’。

Answer 1

INSERT INTO tbl_salary 
(employee_id, salary_month, payable_total, deduction_total, actual_salary)
SELECT e.employee_id, '2021-05-01',
    (e.base_salary + rs.salary + rs.performance_pay) AS payable_total,
    ((e.base_salary + rs.salary + rs.performance_pay - 5000) * 0.03) AS deduction_total,
    ((e.base_salary + rs.salary + rs.performance_pay) - ((e.base_salary + rs.salary + rs.performance_pay - 5000) * 0.03)) AS actual_salary
FROM tbl_employees e
INNER JOIN tbl_rank_salary rs ON e.rank_title = rs.rank_title;