List the details of all rooms at the Grosvenor Hotel, including the name of the guest staying in the room, if the room is occupied.
What will be an ideal response?
SELECT r.* FROM Room r LEFT JOIN
(SELECT g.guestName, h.hotelNo, b.roomNo FROM Guest g, Booking b, Hotel h
WHERE g.guestNo = b.guestNo AND b.hotelNo = h.hotelNo AND
hotelName= ‘Grosvenor Hotel’ AND
dateFrom <= CURRENT_DATE AND
dateTo >= CURRENT_DATE) AS XXX
ON r.hotelNo = XXX.hotelNo AND r.roomNo = XXX.roomNo;
You might also like to view...
In the accompanying figure, the item marked ____ is the file extension.
A. 3 B. 4 C. 5 D. 6
To switch views, click the ___ tab on the Ribbon.
A. Home B. Insert C. View D. Review
You can use commands on the ____ Layout tab to add or delete columns and rows.
A. Tools B. Table C. Update Tables D. Table Tools
Relative humidity should be maintained between ________ to avoid the threats from both low and high humidity.
A. 20% and 80% B. 40% and 60% C. 50% and 50% D. 30% and 70%