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

Question

Exhibit

Options

• ASELECT DISTINCT promo_category || ` has ' || promo_cost AS COSTS FROM promotions
• BSELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
• CSELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
• DSELECT DISTINCT promo_cost ||` in '|| DISTINCT promo_category FROM promotions ORDER
• ESELECT promo_cost, promo_category FROM promotions ORDER BY 1;

• A
  74% (42)
• C
  4% (2)
• D
  14% (8)
• E
  9% (5)

No community discussion yet for this question.