Region Region_Code INT Region_Name VARCHAR(45) Cottage Cottage_ID INT Cottage Name VARCHAR(45) Cottage_NumRooms INT Region_Code INT Indexes Cottage_Facility CF_Num INT Facility_ID INT Cottage ID INT HE----- Indexes Indexes 1 Customer Customer_ID INT Customer_LName VARCHAR(45) Customer_FName VARCHAR(45) Customer_MInitial VARCHAR(5) Customer_Email VARCHAR(45) Customer_Phone VARCHAR(15) Facility Facility_ID INT Facility_Name VARCHAR(45) Facility_IsShared BOOLEAN Indexes Booking Booking_ID INT Booking_Date DATE Booking Price INT Customer_ID INT Cottage_ID INT Indexes H------- Indexes Tourista is looking to expand its business in the province and want to divert more resources to regions where Tourista does not own any cottages. Alice would, therefore, like to see the names of the region(s) where Tourista does not have any cottages. (Hint: Using a sub-query might make your job easier). Run Tests v Grading 1 Full Screen query.sql New SELECT * FROM Region, Cottage WHERE Region_Code IN (SELECT Region_Code FROM offices WHERE Cottage_Num = 0); 8 covouw Test Case 1 0/5 pts - Click for details FAILED Tourista's customer services department informs Alice that people like to book cottages with access to a pool. Alice now wants you to provide her the names of all cottages that do not have a pool in them. Run Tests v Grading 1 1 Full Screen nmin on query.sql New SELECT Cottage Name FROM Cottage C WHERE C.Cottage_ID IN (SELECT CF.Cottage_ID FROM Cottage_Facility CF JOIN Facility USING(Facility_ID) WHERE Facility_Name != 'Pool' Test Case 1 FAILED 0 0/5 pts - Click for details