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