Examine the structure of the products table: 
You want to display the names of the products that have the highest total value for UNIT_PRICE *
QTY_IN_HAND.
Which SQL statement gives the required output?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
Both A and D give the same results.
Can’t be D.
Nested group functions in the subquery are missing their own GROUP BY prod_name.
Correct answer A.