View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE
columns of the promotions table, and the required output format.
Which two queries give the correct result?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE
columns of the promotions table, and the required output format.
Which two queries give the correct result?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
C,D
I think the corrects are A and C.
The prefix fm remove zero and blanks. The last row is January 01.
Option D can’t be correct.
C, D