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’);
You might also like to view...
If a Gedit user wants to paste the text they have copied, what keyboard shortcut can be used?
A. Alt+P B. Alt+V C. Ctrl+X D. Ctrl+V
The Mid function allows you to select the starting point in a text string to select characters, unlike the Left function which always starts with the first character of the text string
Indicate whether the statement is true or false
A(n) ________ is a small line or column that is displayed in a single cell
A) sparkline B) icon C) data bar D) color scale
To save a new presentation for the first time, you use the Save As command.
Answer the following statement true (T) or false (F)