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