View the Exhibit and examine the details of the ORDER_ITEMS table.
Evaluate the following 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 statements are true regarding the output of these SQL statements? (Choose all that apply.)
A. Statement 2 would return multiple rows of output.
B. Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.
C. Statement 1 would not return give the same output.
D. Both the statements would give the same output.
E. Statement 1 would return only one row of output.
BE
ABE