View the Exhibit and examine the structure of the ORDER_ITEMS table.

Examine the following SQL statement:
SELECT order_id, product_id, unit_price
FROM order_items
WHERE unit_price
(SELECT MAX(unit_price)
FROM order_items
GROUP BY order_id);
You want to display the PRODUCT_ID of the product that has the highest
UNIT_PRICE per ORDER_ID. What correction should be made in the above SQL statement to achieve this?

Examine the following query:

What is the output of this query?

Examine the description of the TRANSACTIONS table:

Which two SQL statements execute successfully?

Examine this description of the EMP table:

You execute this query:
SELECT deptno AS "departments", SUM (sal) AS "salary"
FROM emp
GROUP | BY 1
HAVING SUM (sal)> 3 000;
What is the result?

Examine the description of the PRODUCTS table:

Which two statements execute without errors?