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

By | January 1, 2023

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?

Correct Answer: B,D