Write and execute SQL statement(s) to complete each of the following tasks. Copy your SQL statements into the assignment document. Secondly, include the screenshots of results obtained by executing those statements on the DBMS. Typing the results of SQL statements is NOT acceptable.

List the names and addresses of all Australian guests, alphabetically ordered by name.

What would be the total revenue per night from all 'Studio' rooms if all rooms are occupied and booked at their advertised rate?

How many bookings fall in October 2019?

List names of guests who have booked a room at the Beachside Apartments on 13th October 2019.

List the room numbers that are currently occupied at Holiday Inn Express.

List the hotel names and the total number of rooms in each hotel in Indonesia.

Create a 'view' containing the names of all hotels worldwide and their average room rate. Sort the view by increasing price. Finally display the view.

Find out how many children are accompanying Boris Johnson in each of his stays? Show the hotel names and corresponding number of children.

Find phone numbers of all the guests who have or had a booking at Crown Towers in room number 215.

Information about reservations older than 3 years are unlikely to be used in future. For performance reasons, such historical data can be moved to separate archive tables. Write SQL statements to create one or more archival tables with the same structure as original table(s). Using INSERT statement, copy the records of all historical bookings (that ended THREE years before today) from the original tables to the archive tables. Then delete all archived data from the original table(s).

Note: You can recover the original data by reimporting the sql file.

[1.5 marks 10]

. DELL ef D elhi Beli ENERT TO UTE LEITE SE PORIOL TINTO . HTL 1 . . . DELL DELL