MINUTE);INSERT INTO promotions ( promotion_id, name, duration) VALUES ( 6, '20% off Creative Yell', INTERVAL '3 2:25:45' DAY TO SECOND);INSERT INTO promotions ( promotion_id, name, duration) VALUES ( 7, '15% off My Front Line', INTERVAL '123 2:25:45.12' DAY(3) TO SECOND(2));-- commit the transactionCOMMIT;-- insert sample data into order_status tableINSERT INTO order_status ( order_status_id) VALUES ( 1);INSERT INTO order_status ( order_status_id, status, last_modified) VALUES ( 2, 'Order shipped', '10-JUN-2004');-- commit the transactionCOMMIT;-- insert sample data into product_changes tableINSERT INTO product_changes ( product_id, product_type_id, name, description, price) VALUES ( 1, 1, 'Modern Science', 'A description of modern science', 40.00);INSERT INTO product_changes ( product_id, product_type_id, name, description, price) VALUES ( 2, 1, 'New Chemistry', 'Introduction to Chemistry', 35.00);INSERT INTO product_changes ( product_id, product_type_id, name, description, price) VALUES ( 3, 1, 'Supernova', 'A star explodes', 25.99);INSERT INTO product_changes ( product_id, product_type_id, name, description, price) VALUES ( 13, 2, 'Lunar Landing', 'Documentary', 15.99);INSERT INTO product_changes ( product_id, product_type_id, name, description, price) VALUES ( 14, 2, 'Submarine', 'Documentary', 15.99);INSERT INTO product_changes ( product_id, product_type_id, name, description, price) VALUES ( 15, 2, 'Airplane', 'Documentary', 15.99);-- commit the transactionCOMMIT;-- insert sample data into more_products tableINSERT INTO more_products ( prd_id, prd_type_id, name, available) VALUES ( 1, 1, 'Modern Science', 'Y');INSERT INTO more_products ( prd_id, prd_type_id, name, available) VALUES ( 2, 1, 'Chemistry', 'Y');INSERT INTO more_products ( prd_id, prd_type_id, name, available) VALUES ( 3, NULL, 'Supernova', 'N');INSERT INTO more_products ( prd_id, prd_type_id, name, available) VALUES ( 4, 2, 'Lunar Landing', 'N');INSERT INTO more_products ( prd_id, prd_type_id, name, available) VALUES ( 5, 2, 'Submarine', 'Y');-- commit the transactionCOMMIT;-- insert sample data into more_employees tableINSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 1, NULL, 'James', 'Smith', 'CEO', 800000); INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 2, 1, 'Ron', 'Johnson', 'Sales Manager', 600000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 3, 2, 'Fred', 'Hobbs', 'Sales Person', 200000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 4, 1, 'Susan', 'Jones', 'Support Manager', 500000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 5, 2, 'Rob', 'Green', 'Sales Person', 40000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 6, 4, 'Jane', 'Brown', 'Support Person', 45000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 7, 4, 'John', 'Grey', 'Support Manager', 30000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 8, 7, 'Jean', 'Blue', 'Support Person', 29000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 9, 6, 'Henry', 'Heyson', 'Support Person', 30000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 10, 1, 'Kevin', 'Black', 'Ops Manager', 100000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 11, 10, 'Keith', 'Long', 'Ops Person', 50000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 12, 10, 'Frank', 'Howard', 'Ops Person', 45000);INSERT INTO more_employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 13, 10, 'Doreen', 'Penn', 'Ops Person', 47000);-- commit the transactionCOMMIT;-- insert sample data into divisions tableINSERT INTO divisions ( division_id, name) VALUES