Examine the structure of the PROMOTIONS table: The management wants to see a report of unique promotion costs in each promotion category. Which query would achieve the required result?

Question

Exhibit

Options

• ASELECT DISTINCT promo_cost, promo_category FROM promotions;
• BSELECT promo_category, DISTINCT promo_cost FROM promotions;
• CSELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;
• DSELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

• A
  9% (5)
• B
  2% (1)
• C
  6% (3)
• D
  83% (44)

No community discussion yet for this question.