-- DATABASE SYSTEMS 2020
-- LAB EXERCISE 6
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

-- Simple Queries
-- ~~~~~~~~~~~~~~~~~~~~
-- List ALL details of properties that have not yet been rated.


-- List the details of all property owners in the Bristol city area, applying appropriate sorting - be mindful of security implications.


-- List the property bookings scheduled for the first two weeks of November, 
-- showing the property and customer number and check-in date - apply appropriate sorting. 


-- List the properties with a weekday rental price between £30 and £50 listing the most expensive weekday prices first, then orderd by the start date.


-- List all staff members earning  less than £2000.00 per month before tax, etc. in ascending order of salary.


-- List all registered properties in the Swansea postcode region - https://en.wikipedia.org/wiki/SA_postcode_area.





-- Aggregate Functions
-- ~~~~~~~~~~~~~~~~~~~~

-- How many properties are registered with Dream Home Away?


-- How many DIFFERENT clients made bookings last month (September 2019)?


-- How many DIFFERENT properties have a Saturday rental price more than £100?


-- What is the minimum, maximum and average weekday price to rent a property?


-- What is the average rental price per night paid for Holiday Bookings?


-- How much has Dream Home Away earned from bookings made this year.


-- What is the difference between the total rental price of all bookings this year AND the commission Dream Home Away has earned
-- from all bookings made this year.





-- Additional SELECT Query
-- ~~~~~~~~~~~~~~~~~~~~
-- As a staff member of Dream Home Away, you received a phone call from a property owner but cannot remember their name
-- except that the first name starts with the letter M or S and they are based in the Swansea Area
-- Try and find a property owner matching these details in the database
-- List the owner ID, name and contact details of owner(s) found.



-- If the results from the last query produced more than one record, try again using brackets for the name match criteria