purchases tableINSERT INTO purchases ( product_id, customer_id, quantity) VALUES ( 1, 1, 1);INSERT INTO purchases ( product_id, customer_id, quantity) VALUES ( 2, 1, 3);INSERT INTO purchases ( product_id, customer_id, quantity) VALUES ( 1, 4, 1);INSERT INTO purchases ( product_id, customer_id, quantity) VALUES ( 2, 2, 1);INSERT INTO purchases ( product_id, customer_id, quantity) VALUES ( 1, 3, 1);INSERT INTO purchases ( product_id, customer_id, quantity) VALUES ( 1, 2, 2);INSERT INTO purchases ( product_id, customer_id, quantity) VALUES ( 2, 3, 1);INSERT INTO purchases ( product_id, customer_id, quantity) VALUES ( 2, 4, 1);INSERT INTO purchases ( product_id, customer_id, quantity) VALUES ( 3, 3, 1);-- commit the transactionCOMMIT;-- insert sample data into employees tableINSERT INTO employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 1, NULL, 'James', 'Smith', 'CEO', 800000);INSERT INTO employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 2, 1, 'Ron', 'Johnson', 'Sales Manager', 600000);INSERT INTO employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 3, 2, 'Fred', 'Hobbs', 'Salesperson', 150000);INSERT INTO employees ( employee_id, manager_id, first_name, last_name, title, salary) VALUES ( 4, 2, 'Susan', 'Jones', 'Salesperson', 500000);-- commit the transactionCOMMIT;-- insert sample data into salary_grade tableINSERT INTO salary_grades ( salary_grade_id, low_salary, high_salary) VALUES ( 1, 1, 250000);INSERT INTO salary_grades ( salary_grade_id, low_salary, high_salary) VALUES ( 2, 250001, 500000);INSERT INTO salary_grades ( salary_grade_id, low_salary, high_salary) VALUES ( 3, 500001, 750000);INSERT INTO salary_grades ( salary_grade_id, low_salary, high_salary) VALUES ( 4, 750001, 999999);-- commit the transactionCOMMIT;-- insert sample data into purchases_with_timestamp tableINSERT INTO purchases_with_timestamp ( product_id, customer_id, made_on) VALUES ( 1, 1, TIMESTAMP '2005-05-13 07:15:31.1234');-- commit the transactionCOMMIT;-- insert sample data into purchases_with_tz tableINSERT INTO purchases_timestamp_with_tz ( product_id, customer_id, made_on) VALUES ( 1, 1, TIMESTAMP '2005-05-13 07:15:31.1234 -07:00');INSERT INTO purchases_timestamp_with_tz ( product_id, customer_id, made_on) VALUES ( 1, 2, TIMESTAMP '2005-05-13 07:15:31.1234 PST');-- commit the transactionCOMMIT;-- insert sample data into purchases_with_local_tz tableINSERT INTO purchases_with_local_tz ( product_id, customer_id, made_on) VALUES ( 1, 1, TIMESTAMP '2005-05-13 07:15:30 EST');-- commit the transactionCOMMIT;-- insert sample data into coupons tableINSERT INTO coupons ( coupon_id, name, duration) VALUES ( 1, '$1 off Z Files', INTERVAL '1' YEAR);INSERT INTO coupons ( coupon_id, name, duration) VALUES ( 2, '$2 off Pop 3', INTERVAL '11' MONTH);INSERT INTO coupons ( coupon_id, name, duration) VALUES ( 3, '$3 off Modern Science', INTERVAL '14' MONTH);INSERT INTO coupons ( coupon_id, name, duration) VALUES ( 4, '$2 off Tank War', INTERVAL '1-3' YEAR TO MONTH);INSERT INTO coupons ( coupon_id, name, duration) VALUES ( 5, '$1 off Chemistry', INTERVAL '0-5' YEAR TO MONTH);INSERT INTO coupons ( coupon_id, name, duration) VALUES ( 6, '$2 off Creative Yell', INTERVAL '123' YEAR(3));-- commit the transactionCOMMIT;-- insert sample data into promotions tableINSERT INTO promotions ( promotion_id, name, duration) VALUES ( 1, '10% off Z Files', INTERVAL '3' DAY);INSERT INTO promotions ( promotion_id, name, duration) VALUES ( 2, '20% off Pop 3', INTERVAL '2' HOUR);INSERT INTO promotions ( promotion_id, name, duration) VALUES ( 3, '30% off Modern Science', INTERVAL '25' MINUTE);INSERT INTO promotions ( promotion_id, name, duration) VALUES ( 4, '20% off Tank War', INTERVAL '45' SECOND);INSERT INTO promotions ( promotion_id, name, duration) VALUES ( 5, '10% off Chemistry', INTERVAL '3 2:25' DAY TO