Examine the description of the PROMOTIONS table: 

You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.) 

Answer options:

A. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
B. SELECT DISTINCT promo_cost || ` in "˜ || DISTINCT promo_category FROM promotions ORDER BY 1;
C. SELECT DISTINCT promo_category || "˜ has "˜ || promo_cost AS COSTS FROM promotions ORDER BY 1;
D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

DE