How many different guests have made bookings for August?

What will be an ideal response?

SELECT COUNT(DISTINCT guestNo) FROM Booking
WHERE (dateFrom <= DATE’2004-08-01’ AND dateTo >= DATE’2004-08-01’) OR
(dateFrom >= DATE’2004-08-01’ AND dateFrom <= DATE’2004-08-31’);

Computer Science & Information Technology

You might also like to view...

Starting more than one application at a time is known as ________.

a. workload increase b. loading foreground c. multitasking d. convergence

Computer Science & Information Technology

________ boxes are movable, linkable, resizable containers for texts or graphics

Fill in the blank(s) with correct word

Computer Science & Information Technology