View the Exhibit and examine the description of the PRODUCT_INFORMATION table.
SELECT product_name, list_price, min_price, list_price – min_price Difference FROM
product_information
Which options when used with the above SQL statement can produce the sorted output in
ascending order of the price difference between LIST_PRICE and MIN_PRICE? (Choose all that
apply.)
A.
ORDER BY 4
B.
ORDER BY MIN_PRICE
C.
ORDER BY DIFFERENCE
D.
ORDER BY LIST_PRICE
E.
ORDER BY LIST_PRICE – MIN_PRICE