-- DATABASE MANAGEMENT SYSTEMS 2019/20
-- 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 next 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 ANY preferences, including rent they are willing to pay, for the property they wish to rent.


-- Consider an application displaying 20 properties at a time on a page, sorted by the property number, and the user is currently on the first page
-- Write a query to fetch the list of properties for this page


-- The user from the last query has used the list of pages at the bottom of the page to skip to page 3
-- Write a query to fetch the list of properties for this page





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

-- How many properties are registered with Dream Home?


-- How many DIFFERENT clients have made appointments to view properties in the last quarter of this year (Oct - Dec)?
-- If you get a number over 20, try again :)


-- 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 has DreamHome earned from renting properties whose rental period started and ends within this year, specifically rental period started and finished in the current year?
-- If you got a figure just over 10,000 for this question, you are way off the mark :). Try again - it is higher.



-- How much did DreamHome earn from properties whose rental period started and finished in the last year?
-- If you got a figure under 1,000 for this question, you are way off the mark :). Try again - it is much higher.