Table ORDER ITEMS contains columns ORDER ID, UNIT PRICE and QUANTITY, of
Data type NUMBER.
Examine these SQL statements
Statement1:
SELECT MAX(unit_price * quantity) "Maximum Order" FROM order_items;
Statement2:
SELECT MAX(unit_price * quantity) "Maximum Order" FROM order_items GROUP BY order_id;
Which two statements are true?
A.Statement 1 returns only one row of output. B.Statement 2 may return multiple rows of output. C.Statement 2 returns only one row of output. D.Both the statements give the same output. E.Both statements will return NULL if either UNIT PRICE or QUANTITY contains NULL正确答案AB
