INSERT INTO ch16_award (award_description, amount_eur) VALUES ('GOLD', '100'); INSERT INTO ch16_award (award_description, amount_eur) VALUES ('SILVER', '80'); INSERT INTO ch16_award (award_description, amount_eur) VALUES ('BRONZE', '60'); INSERT INTO ch16_award (award_description, amount_eur) VALUES ('CONTRIBUTOR', '40'); INSERT INTO ch16_award (award_description, amount_eur) VALUES ('THANK YOU', '5'); INSERT INTO ch16_employee (fname, lname, email, manager) VALUES ('Janez', 'Novak', 'janez.novak@beeapex.eu', null); INSERT INTO ch16_employee (fname, lname, email, manager) VALUES ('Petra', 'Kovac', 'petra.kovac@beeapex.eu', '1'); INSERT INTO ch16_employee (fname, lname, email, manager) VALUES ('Drew', 'Cooper', 'drew.cooper@beeapex.eu', '1'); INSERT INTO ch16_employee (fname, lname, email, manager) VALUES ('Regina', 'Palmer', 'regina.palmer@beeapex.eu', '1'); INSERT INTO ch16_employee (fname, lname, email, manager) VALUES ('Adam', 'Salt', 'adam.salt@beeapex.eu', '3'); INSERT INTO ch16_employee (fname, lname, email, manager) VALUES ('Sofia', 'Gordon', 'sofia.gordon@beeapex.eu', '2'); INSERT INTO ch16_employee (fname, lname, email, manager) VALUES ('Michael', 'Wilson', 'michael.wilson@beeapex.eu', '2'); INSERT INTO ch16_employee (fname, lname, email, manager) VALUES ('Norma', 'Butler', 'norma.butler@beeapex.eu', '5'); INSERT INTO ch16_idea (contributor, submission_date, title) VALUES ('2', '01/01/2023', 'Mail service should be optimized'); INSERT INTO ch16_idea (contributor, submission_date, title) VALUES ('3', '02/02/2023', 'Collection of innovative ideas'); INSERT INTO ch16_idea (contributor, submission_date, title) VALUES ('5', '05/02/2023', 'Teambuilding event'); INSERT INTO ch16_idea (contributor, submission_date, title) VALUES ('5', '01/02/2023', 'Decentralized operations'); INSERT INTO ch16_idea (contributor, submission_date, title) VALUES ('2', '03/02/2023', 'Shared printers'); INSERT INTO ch16_idea (contributor, submission_date, title) VALUES ('4', '06/02/2023', 'Queue of material');