You have a query that retrieves data for employees who took vacation for a specific duration (for
example, two weeks). You want to change this query so that it will prompt the user to enter a value
for the duration of the vacation. To achieve this result, which action would you take?
A.
Add a prompt to further refine the query when it is run.
B.
Define expressions to calculate the duration of a vacation.
C.
Define a HAVING criterion to display the duration of a vacation.
D.
Apply aggregate functions to determine the duration of a vacation.