Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER. Examine these
Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and 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_itemsGROUP BY order_id;Which two statements are true? A. Statement 1 returns only one row of output. B. Statement 2 returns only one row of output. C. Both statements will return… Read More »