Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER. Examine these

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) “Maximum Order”
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) “Maximum Order”
FROM order_items
GROUP BY order_id;
Which two statements are true?

A. Both the statements give the same output.

B. Statement 1 returns only one row of output.

C. Statement 2 returns only one row of output.

D. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

E. Statement 2 may return multiple rows of output.

Correct Answer: D,E