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.

• A

  SELECT promo_name, TO_CHAR(NVL(promo_end_date -promo_start_date, 'ONGOING')) FROM
  promos;

• B

  SELECT promo_name, COALESCE(TO_CHAR(promo_end_date - promo_start_date), 'ONGOING') FROM promos;

• C

  SELECT promo_name, NVL(TO_CHAR(promo_end_date -promo_start_date), 'ONGOING') FROM
  promos;

• D

  SELECT promo_name, DECODE(promo_end_date-promo_start_date, NULL, 'ONGOING',
  promo_end_date - promo_start_date) FROM promos;

• E

  SELECT promo_name, ecode(coalesce(promo_end_date, promo_start_date), null, 'ONGOING',
  promo_end_date - promo_start_date)FROM promos;