To display the names of all promos done after January 1, 2001 starting with the latest promo. Which query would give the required result? (Choose all that apply.)
Answer options
A
SELECT promo_name, promo_begin_date "START DATE" FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY "START DATE" DESC;
B
SELECT promo_name, promo_begin_date FROM promotions ORDER BY promo_begin_date;
C
SELECT promo_name FROM promotions WHERE promo_begin_date > '01-JAN-01';
D
SELECT * FROM promotions ORDER BY promo_begin_date DESC;
Correct answer: SELECT promo_name, promo_begin_date "START DATE" FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY "START DATE" DESC;
Explanation
The query filters by date, uses a column alias 'START DATE', and orders descending.