-- DATABASE MANAGEMENT SYSTEMS 2015/16
-- LAB EXERCISE 5
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

-- Simple Queries
-- ~~~~~~~~~~~~~~~~~~~~
-- List the details of all business property owners, applying appropriate sorting - be mindful of security implications.


-- List the property viewings scheduled for this week, showing the property and client number and viewing date and time - apply appropriate sorting. 


-- List the properties in Swansea and with a rental value between £350 and £750 in ascending order of rental price and descending order of rooms.


-- List all properties with a rental price of less than £20.00 per day (assume a month has 30 days) in ascending order of rental price.


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


-- List the client number, name and contact details of all clients who have not yet indicated their preference for the type of property they wish to rent.



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

-- How many properties are registered with Dream Home?


-- How many different clients have made appointments to view properties this month (November 2016)?


-- How many different properties cost more than £600 per month to rent?


-- What is the minimum, maximum and average rental cost of all registered properties?


-- What is the average price of a two-bedrom property in the Swansea postcode region?


-- How much did DreamHome earn from renting properties last year?
-- If you got a figure just over 10,000 for the last question, you are way off the mark :). Try again - it is much higher.