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 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;
Examine the description of the PROMOTIONS table:You want to display the unique promotion costs in each promotion categor
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am