examine the structure of the PROMOTIONS table: (Choose the best answer)
Management requires a report of unique promotion costs in each promotion category. Which query would satisfy this requirement?
A. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1
B. SELECT promo_category DISTINCT promo_cost FROM promotions
C. SELECT DISTINCT promo_cost, promo_category FROM promotions
D. SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;
Just A
A
A . need to add group by promo_category,promo_cost
C. need to add group by promo_cost,promo_category
C is correct
A