Q5
Multiple choice
Examine the structure of the PROMOS table:

You want to generate a report showing promo names and their duration (number of days).
If the PROMO_END_DATE has not been entered, the message 'ONGOING' should be displayed.
Which queries give the correct output?
(Choose all that apply.)
Select all that apply.