Which query would satisfy this requirement?

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;

Download Printable PDF. VALID exam to help you PASS.

5 thoughts on “Which query would satisfy this requirement?

  1. A . need to add group by promo_category,promo_cost
    C. need to add group by promo_cost,promo_category

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.