Pls create this database

$6\mathrm{.}7$ List full details of all hotels.

$6\mathrm{.}8$ List full details of all hotels in London.

$6\mathrm{.}9$ List the names and addresses of all guests living in London, alphabetically ordered by name.

$6\mathrm{.}10$ List all double or family rooms with a price below $40\mathrm{.}00$ per night, in ascending order of price.

$6\mathrm{.}11$ List the bookings for which no dateTo has been specified.

Aggregate functions

$6\mathrm{.}12$ How many hotels are there?

$6\mathrm{.}13$ What is the average price of a room?

$6\mathrm{.}14$ What is the total revenue per night from all double rooms?

$6\mathrm{.}15$ How many different guests have made bookings for August?

$230|$ Chapter $6$ SQL: Data Manipulation

M$06\_$CONN$3067\_06\_$SE$\_$C$06.$indd $23010/06/143$:$23$ PM

Subqueries and joins

$6\mathrm{.}16$ List the price and type of all rooms at the Grosvenor Hotel.

$6\mathrm{.}17$ List all guests currently staying at the Grosvenor Hotel.

$6\mathrm{.}18$ List the details of all rooms at the Grosvenor Hotel, including the name of the guest staying in the room, if the room is occupied.

$6\mathrm{.}19$ What is the total income from bookings for the Grosvenor Hotel today?

$6\mathrm{.}20$ List the rooms that are currently unoccupied at the Grosvenor Hotel.

$6\mathrm{.}21$ What is the lost income from unoccupied rooms at the Grosvenor Hotel?

Grouping

$6\mathrm{.}22$ List the number of rooms in each hotel.

$6\mathrm{.}23$ List the number of rooms in each hotel in London.

$6\mathrm{.}24$ What is the average number of bookings for each hotel in August?

$6\mathrm{.}25$ What is the most commonly booked room type for each hotel in London?

$6\mathrm{.}26$ What is the lost income from unoccupied rooms at each hotel today?

Populating tables

$6\mathrm{.}27$ Insert rows into each of these tables.

$6\mathrm{.}28$ Update the price of all rooms by $5\%.$