List all guests currently staying at the Grosvenor Hotel.

What will be an ideal response?

SELECT * FROM Guest
WHERE guestNo =

(SELECT guestNo FROM Booking
WHERE dateFrom <= CURRENT_DATE AND
dateTo >= CURRENT_DATE AND
hotelNo =
(SELECT hotelNo FROM Hotel
WHERE hotelName = ‘Grosvenor Hotel’));

Computer Science & Information Technology

You might also like to view...

What do you use to preview more than one page at a time prior to printing?

A) Click the number of pages you want to preview B) Click Home tab, click Print Preview, and choose the number of pages to preview C) Use the zoom slider or Zoom to Page setting D) Click the number of pages you want to preview under the Settings area

Computer Science & Information Technology

The technique where memory is expanded to hold three, four, or more programs and switch among all of them is __________, (or multitasking).

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology