What is the lost income from unoccupied rooms at each hotel today?

What will be an ideal response?


SELECT hotelNo, 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)

GROUP BY hotelNo;

Computer Science & Information Technology

You might also like to view...

Visual Basic evolved from the _________ programming language.

a) assembly b) BASIC c) DOS d) Java.

Computer Science & Information Technology

To enable macros in Excel, you must set the security level on the ________

A) Macro tab B) Developer tab C) Visual Basic tab D) Security tab

Computer Science & Information Technology

HIPAA enables access to PHI on a ____________ basis

a. Need-to-know b. Doctor-only c. Hospital staff-only d. None of the above

Computer Science & Information Technology

Which of the following class has public constructors?

A. Stream B. TextReader C. File D. StreamReader

Computer Science & Information Technology