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’);
You might also like to view...
Motion, like transitions and animations, along with multimedia elements, such as audio and video, can enhance presentations
Indicate whether the statement is true or false
A variable that will be used to contain only nondecimal whole numbers should be declared as a(n) ____ data type.
A. Decimal B. Double C. Integer D. Single
A port may be ____.
A. ?open B. ?closed C. ?stealth D. ?any of the above
What is a functional decomposition diagram (FDD) and why would you use one? Explain how to create an FDD.
What will be an ideal response?