AT&T LTE 1 40%D 9:19 PM Homework_2.pdf X Homework 2 Generate the SOL expressions for the following queries based on Use the Hotel schema defined in homework 1. L List full details of all hotels 2. List details of all hotels in Orlando 2. List the names and addresses of all guests living in Tuskegee, alphabetically ondered by 4. List all double or family rooms with a price below $100.00 per nicht in ascending order of price. 5. List the booking for which me date has been specified 6. How many hotels in Orlando? 7. What is the average price of a room? 8. What is the total revenue per night from all rooms? 9. How many different guests have made bookings for August? 10. List the price and type of all rooms at the Grosvenor Hotel 11. List allats currently staying at the Grosvenor Hotel 12. List the details of all rooms at the Grosvenor Hotel including the name of the guest staying in the room, the room is occupied 13. What is the total income from bookings for the Grosvenor Hotel today? 14. List the rooms that are currently unoccupied at the Grosvenor Hotel 15. What is the lost income from unoccupied rooms at the Grosvenor Hotel 16 List the number of rooms in each hotel 17. List the number of rooms in each hotel in Orlando 18. What is the average number of bookings for each hotel in August? 19. What is the most commonly booked room type for each hotel in London? 20. What is the lost income from nocoupled rooms at each hotel on 17