5. Use XAMPP Control Panel (My SQL) to answer the following questions. Write SQL queries statement and also provide the output of each query to answer the following questions. (Screenshot the interface in MySQL that show SQL statement and output for each question). Table 1: PROPERTY pid 1 2 price 100000 3400000 3 1200000 4 5000000 owner Alia Bob Bob Marsha Table 2: MAINTENANCE mid company Name M1 Super Plumbing M2 Super Plumbing M3 srqFeet 560 2000 1200 800 empName George Dave South Carpeting Kim b) Insert all records to both tables. I managedBy Property Pete Park Property Property Pete Fancy Property date 2020-12-12 2020-11-11 2021-01-01 location Lake View type Sink Toilet Serene Serene Lake View Pid 1 1 Painting 4

SQL knowledge question

Create a PL/SQL database programming block with DECLARE BEGIN   END; In Declare section define a local scalar (simple) variables. lv_deptno  NUMBER And assign initial values as 10 lv_deptno  NUMBER := 50; In Declare section again, define a cursor and select last_name, salary and manager_id of employees the ones who are working in the department defined in a) In this example department will be lv_deptno:=50;   Sample code:   Cursor c_emp as   SELECT last_name, salary, manager_id FROM employees   WHERE department_id =    lv_deptno;   In the execution section (BEGIN and END) Create CURSOR FOR LOOP for cursor to process In this cursor loop, your code has to check salary and also manager_id  numbers each time new records being fetched. And based on these conditions either employee gets raise or not get raise. If employee salary is less than 5000 and also if employees managers is either 101 or 124 then it means employee is due for raise otherwise employee is not due for raise   Sample…

write sql function to calculate GPA as seen on my image sent