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 is a simple protocol that is used by applications that contain their own connection-oriented timeout values and retry counters, similar to those provided by TCP?

A. UDP B. DoS C. RTO D. MSS

Computer Science & Information Technology

What kind of iterators does the stack template container have?

What will be an ideal response?

Computer Science & Information Technology

____________________ means taking economic considerations into account when deciding what critical tasks to shorten.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

An IP address is composed of two parts, one is the ____________ ID and one is the host ID.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology