Q116 Examine the description of the PROMOTIONS table

Q116 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.)

• (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;