O. Write SQL statements to switch the values of ExperienceLevel so that all rows currently having the value Junior will have the value Senior and all rows currently having the value Senior will have the value Junior.

UPDATE EMPLOYEE

SET ExperienceLevel = 'Senior'

WHERE ExperienceLevel = 'Junior';

UPDATE EMPLOYEE

SET ExperienceLevel = 'Junior'

WHERE ExperienceLevel = 'Senior';

(Is this right?)

P. Given assumptions about cascading deletions, write the fewest number of DELETE statements possible to remove all the data in your database but leave the table structures intact. Do not run these statement if you are using an actual database.

Page of 2 FIGURE 3-39 Sample Data for Garden Glory OWNER Table OwnerID OwnerName Mary Joncs DT Enterprises Sam Douglas UNY Enterprises Doug Samuels OwnerEmailAddress Mary.Jones@somewhere.com DTE@dte.com Sam.Douglas@somewhere.com UNYE@unye.com Doug.Samuels@somewhere.com OwnerType Individual Corporation Individual Corporation Individual FIGURE 3-43 Sample Data for Garden Glory PROPERTY_SERVICE Table PropertyServicelD PropertyIID ServiceID Hours Worked ServiceDate 2017-05-05 2017-05-08 2017-05-08 2017-05-10 2017 05-12 2017-05-15 2017-05-19 2017-05-21 2017-06-03 2017-06-08 2017-06-12 2017-06-15 2017-06-19 EmployeeID 4.50 4.50 2.75 2.50 7.50 2.75 1.00 2.50 2.50 10.50 2.75 5.00 4.00 2 10 12 13