Database for Management Information System

Simple Queries

1List full details of all hotels.

2 List full details of all hotels in London.

3 List the names and addresses of all guests in London, alphabetically ordered by name.

4List all double or family rooms with a price below 40.00 per night, in ascending order of price.

5List the bookings for which no dateTo has been specified.

Aggregate Functions

6How many hotels are there?

7What is the average price of a room?

8What is the total revenue per night from all double rooms?

9How many different guests have made bookings for August?

Subqueries and Joins

10List the price and type of all rooms at the Grosvenor Hotel.

11List all guests currently staying at the Grosvenor Hotel.

12List the details of all rooms at the Grosvenor Hotel, including the name of the guest staying in the room, if the room is occupied

13What is the total income from bookings for the Grosvenor Hotel today?

14List the rooms that are currently unoccupied at the Grosvenor Hotel.

Grouping

15List the number of rooms in each hotel.

16List the number of rooms in each hotel in London.

17What is the average number of bookings for each hotel in August?

18What is the most commonly booked room type for each hotel in London?

19What is the lost income from unoccupied rooms at each hotel today?

Populating Tables

20Update the price of all rooms by 5%.

Descending Advanced . save 2 TelalhRemo Sort Spelling Replace Anal Detain Ascending YrSelection *Save All . "X Delete , Tope Fier allX DeleteMor Descending Advanced. Spelling Sort & Filter . Records Select BI Find More . Remove Sort Y Toggle Fiter Find Sot & Filter gustNo -gustName-gustAddres-Click to Add hotelNo guestNodateForm dataToroomNo Click to Add 3 M33 5 Y9 22 kail33 23 kail34 3232B 3222C 45 T77 MLT5 Ascendingg Advanced. Selection New Totals Table Tools e Save Retresh X Delete Filter Descending Advanced- Spelling | Remove Sort YToggie Filter | Retres"X Delete-BMore. Data Database Tools Add-Ins Fields Table Find Selection New Totals Replace Sort & Filtter Records DescendingAdvanced . bRemove Sort YToggie Fiter Delete , 'Spelling Retres"X Delete, Find More . Select " hotelNo hotelNamecity Click to Add Sort & Filter 21 sofotel 22 helton 23 RITZ hotelNo khobar price Click to Add 20 30 50 roomNo type 1 50.00 6 60.00 5 80.00 7