25, 'SAL', 'MGR', 'Gerald', 'Gold', 245000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 26, 'SAL', 'MGR', 'Eileen', 'Lane', 235000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 27, 'SAL', 'MGR', 'Doreen', 'Upton', 235000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 28, 'SAL', 'MGR', 'Jack', 'Ewing', 235000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 29, 'SAL', 'MGR', 'Paul', 'Owens', 245000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 30, 'SAL', 'MGR', 'Melanie', 'York', 255000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 31, 'SAL', 'MGR', 'Tracy', 'Yellow', 225000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 32, 'SAL', 'MGR', 'Sarah', 'White', 235000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 33, 'SAL', 'MGR', 'Terry', 'Iron', 225000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 34, 'SAL', 'MGR', 'Christine', 'Brown', 247000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 35, 'SAL', 'MGR', 'John', 'Brown', 249000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 36, 'SAL', 'MGR', 'Kelvin', 'Trenton', 255000);INSERT INTO employees2 ( employee_id, division_id, job_id, first_name, last_name, salary) VALUES ( 37, 'BUS', 'WOR', 'Damon', 'Jones', 280000);-- commit the transactionCOMMIT;-- insert sample data into all_sales tableINSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 1, 10034.84);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 2, 15144.65);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 3, 20137.83);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 4, 25057.45);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 5, 17214.564);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 6, 15564.64);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 7, 12654.84);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 8, 17434.82);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 9, 19854.57);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 10, 21754.19);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 11, 13029.73);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 1, 2003, 12, 10034.84);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 2, 2003, 1, 1034.84);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 2, 2003, 2, 1544.65);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 2, 2003, 3, 2037.83);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 2, 2003, 4, 2557.45);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 2, 2003, 5, 1714.564);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 2, 2003, 6, 1564.64);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount) VALUES ( 21, 2, 2003, 7, 1264.84);INSERT INTO all_sales ( emp_id, prd_type_id, year, month, amount)