🚀 go-pugleaf

Hi, I am taking a database course and I am really stuck on some
difficult material.  I have spent about 24 hours banging my head
against the wall and my instructor says I am totally wrong. 

I did very well in my intro to computer course, but nobody in my class
has been able to solve all these  SQL Questions.  If you could lend a
helping hand it would be greatly appreciated.

Please email me or my partner at ricecube@hotmail.com or
comp1450@hotmail.com thank you very much in advance. Here is the
actual question from the teacher:


Use the database (Hotel97).  Print the results for each SQL Statement
(print the datasheet) as well as the SQL statement.  Use SQL syntax
and format discussed in lecture.  Please do NOT copy the SQL Access
generates. 

Hotel(Hotel_No, Name, Address, City) 
Room(Room_No, Hotel_No, Type, Price) 
Booking(Hotel_No, Guest_No, Date_From, Date_To, Room_No) 
	Note:  date_to is the day the guest is checking out.
Guest(Guest_No, Name, Address, City)


1. List full details of all hotels. (do not include room information)
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 double or family rooms with a price below $60.00 per
night, in ascending order of price.
5. List the booking for which no date_to has been specified.
6. How many hotels are there?
7. What is the average price of a room?
8. What is the total revenue per reservation from all double rooms?
9. How many guests (distinct) have made bookings for August, 1997 in
each hotel?
10. List the price and type of all rooms in the Grosvenor Hotel.
11. List all the guests currently staying at the Grosvenor Hotel on
August 1,1997.
12. What is the total income from bookings (occupied rooms) for the
Grosvenor Hotel for August 1, 1997?
13. List unoccupied rooms at the Grosvenor Hotel during August 1,
1997.
14. What is the lost income from unoccupied rooms at the Grosvenor
Hotel during August 1, 1997?
15. List the number of rooms in each hotel.

DUE: (before the final exam)