How would i go about writing a sql Query: Tourista's CEO is also concerned that cottages in some regions are not very profitable. She wants a list of all region names where none of the cottages were ever booked for a price over 500. (Note: Your list should exclude Regions with no cottages).

 

Region Region Code INT Region Name VARCHAR(45) Indexes Customer Customer_ID INT Customer_LName VARCHAR(45) Customer_FName VARCHAR(45) Customer_MInitial VARCHAR(5) Customer_Email VARCHAR(45) Customer_Phone VARCHAR(15) Indexes -H- Cottage Cottage_ID INT Cottage Name VARCHAR(45) Cottage_NumRooms INT Region Code INT Indexes Booking Booking ID INT Booking_Date DATE Booking Price INT Customer_ID INT Cottage_ID INT Indexes --H- Cottage Facility CF_Num INT Facility_ID INT Cottage ID INT Indexes Facility Facility ID INT Facility_Name VARCHAR(45) Facility_IsShared BOOLEAN Indexes