The following tables form part of a database held in a relational DBMS:
Hotel (h)
hotelNo, hotelName, city
Room (r)
roomNo, hotelNo, type, price
Booking (b)
bookingNo, hotelNo, guestNo, dateFrom, dateTo, roomNo
Guest (g)
guestNo, guestName, guestAddress
where the bolded attributes are the primary keys for the respective tables. Using the above tables, answer the following questions:
1. List the names and addresses of all guests in London, alphabetically ordered by name.
2. List all double or family rooms with a price below $40.00 per night, in ascending order of price.
3. What is the total revenue per night from all double rooms?