140.Examine the structure of the PRODUCTS table:

140.Examine the structure of the PRODUCTS table:
name         Null     Type
PROD_ID      NOT NULL NUMBER(4)
PROD_NAME             VARCHAR2(20)
PROD_STATUS           VARCHAR2(6)
QTY_IN_HAND           NUMBER(8,2)
UNIT_PRICE            NUMBER(10,2)


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.SELECT prod_name FROM products
WHERE (unit_price * qty_in_hand) = (SELECT MAX(unit_price * qty_in_hand) FROM products);
B.SELECT prod_name FROM products 
WHERE (unit_price * qty_in_hand) = (SELECT MAX(unit_price * qty_in_hand) FROM products
GROUP BY prod_name);
C.SELECT prod_name FROM products GROUP BY prod_name
HAVING MAX(unit_price * qty_in_hand) = (SELECT MAX(unit_price * qty_in_hand) FROM products
GROUP BY prod_name);
D.SELECT prod_name FROM products
WHERE (unit_price * qty_in_hand) = (SELECT MAX(SUM(unit_price * qty_in_hand)) FROM products)
GROUP BY prod_name;
答案：A
解析：
A:正确
B:错误，子查询为多行子查询，返回的可能为多行，但是前面使用了=号，有问题
C:错误，和b一样返回多行
D:错误，和b一样，并且这里sum也不对