Please insert at least $20$ records to each table in your schema; please note that you need to ensure all your queries return one row, so please ensure that the records you insert after creating the tables meet the criteria. You can insert more than $20$ rows, but anything less than $20$ will impact your grades. Please note that if your schema has four tables; you are required to insert $20$ rows to each table which will be $(20*4=80).$ pls help create a format for the table and row.

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

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\%.$