CREATE TABLE spayroll (
id int,
empId int,
baseSalary double,
actualSalary double,
bonus double,
deductMoney double,
grantDate date
);
INSERT INTO payroll VALUES (1, '0001', '1000', '1000','1000','10','2021-06-06');
INSERT INTO payroll VALUES (2, '0002', '1000', '1000','1000','10','2021-06-06');
INSERT INTO payroll VALUES (3, '0003', '1000', '1000','1000','10','2021-06-06');
INSERT INTO payroll VALUES (4, '0004', '1000','1000', '1000','10','2021-06-06');
INSERT INTO payroll VALUES (5, '0005', '1000', '1000','1000','10','2021-06-06');
SELECT * FROM payroll;