What is the lost income from unoccupied rooms at the Grosvenor Hotel?
What will be an ideal response?
SELECT SUM(price) FROM Room r
WHERE roomNo NOT IN
(SELECT roomNo FROM Booking b, Hotel h
WHERE (dateFrom <= CURRENT_DATE AND
dateTo >= CURRENT_DATE) AND
b.hotelNo = h.hotelNo AND hotelName = ‘Grosvenor Hotel’);
Computer Science & Information Technology
You might also like to view...
Which of the following, from outermost to innermost, are components of the box model?
a. margin, border, padding, content b. content, padding, border, margin c. content, margin, padding, border d. margin, padding, border, content
Computer Science & Information Technology
A cold site provides which of the following?
A. Hardware systems B. Software systems C. Power and air conditioning systems D. The servers
Computer Science & Information Technology