What is the total income from bookings for the Grosvenor Hotel today?
What will be an ideal response?
SELECT SUM(price) FROM Booking b, Room r, Hotel h
WHERE (dateFrom <= CURRENT_DATE AND
dateTo >= CURRENT_DATE) AND
r.hotelNo = h.hotelNo AND r.roomNo = b.roomNo AND
hotelName = ‘Grosvenor Hotel’;
Computer Science & Information Technology
You might also like to view...
Alice function_______ calls the function it receives as an argument continuously.
a) Call. b) Loop. c) Move. d) None of the above.
Computer Science & Information Technology
Communications hardware includes modems, which are used to connect a computer to the Internet and network projectors, which are used to connect a computer to a computer network. _________________________
Answer the following statement true (T) or false (F)
Computer Science & Information Technology