WRITE PL/SQL query with output in oracle software. don't give answer in any other programming language like python or java

Chris owns auto repair business wants to calculate the weekly salary of employees Based on the following criteria 1. If an employee works over 40 hours in a week, Chris pays that employee 1.5 times his or her regular hourly pay rate for all hours over 40. (.e. for 65 hours = 40 hours normal rate + 25 hours overtime pay.(assume that Hourly rate is 14.00) 2. If it is less than 40 hours (or 40), employees are paid on normal hourly rate Design a PL/SQL program to calculate the gross salary of his employees (.e. total salary) Guideline Use the following algorithm: 1. Get the number of hours worked. 2. Get the hourly pay rate. 3. If the employee worked more than 40 hours, calculate the gross pay with overtime. Otherwise, calculate the gross pay as usual. 53 54 55 33 S6. 57 58 . 59. 60. 61 . 3 62 o 63 INSERI INTO employees VALUES ( 110, 'Lauren', 'M', 'Alexander', 749583756, DEFAULT, 4500 INSERT INTO employees VALUES ( 111, 'Lisa', L', ames) 396812058, DEFAULT, 65806 INSERT INTO employees VALUES ( 112, Dave, ', 'Bernard', 184759364, DEFAULT, 6000 INSERT INTO employees VALUES ( 113, 'Steve', 'L', 'Care', 018593745, DEFAULT, 5500 INSERT INTO employees VALUES ( 114, Marg', 'A', 'Horners 947581253, DEFAULT, 4500 INSERT INTO employees VALUES ( 124, 'Scott's , 'Long's 912058121, DEFAULT, 35808 INSERT INTO employees VALUES ( 115, 'm', Best', 184629673, DEFAULT, 2400 INSERT INTO employees VALUES ( 126, 'Sue', "A *McDonald', 285912756, DEFAULT, 3600 INSERT INTO employees VALUES ( 117, Trish', s', 'Albert 649105738, DEFAULT, 1800 INSERT INTO employees VALUES ( 125, Terry', '9, 'Maxwell, 385937712, DEFAULT, 2200 INSERT INTO employees VALUES ( 119, 'Dave', 'Nisbet's 759127547, DEFAULT, 3980 INSERT INTO employees VALUES ( 128, 'Anne's 'M', 'Richie', 834577193, DEFAULT, 4000 INSERT INTO employees VALUES ( 122, 'Jake', *L, "Lee', 812954926, DEFAULT, 4500 INSERT INTO employees VALUES ( 118, Janice', 'B', 'Harper', 912758396, DEFAULT, 2900 INSERT INTO employees VALUES ( 123, Linda', 'M', 'Johnson', 295734812, DEFAULT, 2400 INSERT INTO employees VALUES ( 121, 'William', 'y', 'Johnson', 374912745, DEFAULT, 3100 INSERT INTO employees VALUES ( 127, 'Sharron', 'Evans 492337745, DEFAULT, 2900 TNSERT INTO emnlnvee VALIF / 116. Onhart. HARP 51 REAL FEAT. 27 64. 65 . 66 67 68 - 69 70. 21. Cont