Examine the description of the PROMOTIONS table:You want to display the unique promotion costs in each promotion categor

[answerhappygod]

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

Examine The Des 1 (36.13 KiB) Viewed 136 times

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