Examine the data in the PROMO_BEGIN_DATE column of the promotions table:
You want to display the number of promotions started in 1999 and 2000.
Which query gives the correct output?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Which query gives the correct output?
Examine the data in the PROMO_BEGIN_DATE column of the promotions table:
You want to display the number of promotions started in 1999 and 2000.
Which query gives the correct output?
Count is wrong, should use sum.
also yyyy will return 4 digit year