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’;
You might also like to view...
Editable regions of a template are the only regions that can contain unique page content.
Answer the following statement true (T) or false (F)
The set accessor enables you to .
a) provide range checking b) modify data c) provide data validation d) All of the above.
An advantage of structured programming is that structures can be pulled out of programs and inserted into other programs without adversely affecting the flow of the surrounding code.
Answer the following statement true (T) or false (F)
One of the other colors in the color scheme is intended to provide a look of authority and power. What is that color?
a. blue b. yellow-green c. orange d. black