Write a SQL query for each of the following commands: $1.$ List 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, $4.$ List all single or double rooms with a price below $40\mathrm{.}00$ per night, in ascending order of price. $5.$ How many hotels are there? $6.$ What is the total revenue per night from all double rooms if they all are fully booked? $7.$ List the price and type of all rooms at the Grosvenor Hotel if they all are fully booked. $8.$ List full details of the rooms that are currently unoccupied at the Grosvenor Hotel. $9.$ List the number of rooms in each hotel in London. $10.$ What is the most commonly booked room type for each hotel in London? Hotel Relational Database Hotel table hotelNo hotelName Hyatt Hilton Grosvenor Renaissance Ritz$-$Carlton city Paris Paris H$2$ H$3$ London London Seoul Room table roomNo R$1$ hotelNo I HA H$1$ H$2$ H$3$ R$3$ roomType Single Double Queen King Quad Single Double King King $42$ H$22025$ H$1$ R$9$ Booking table hotelNo H$3$ guestNo dateFrom $1$ Jan $201625$ July $20181-$May$-201710$ Dec $2016$ dateTo $7.$ Jan $20162$ Aug $201810$ May $201715$ Dec $2016$ roomNo R$4$ R$6$ RS H$3$ H$4$ TRI Guest table guestNo guest Name John Smith Mary Kim Terry Brown Michael Johnson I guest Address $111$ Perthshire Rd$,$ London $456$ Main St$,$ Houston $235$ Holleman Dr$.$ Paris $980$ Ball St$.$ New York