List the rooms that are currently unoccupied at the Grosvenor Hotel.
What will be an ideal response?
SELECT * 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...
The ________ tab must be displayed on the Ribbon before you can create a form
Fill in the blank(s) with correct word
Computer Science & Information Technology
A _________ loop always executes the loop body at least once, irregardless of the loop condition.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology