View the Exhibit and examine the description of the ORDER_ITEMS table.
The following SQL statement was written to retrieve the rows for the PRODUCT_ID that has a
UNIT_PRICE of more than 1,000 and has been ordered more than five times:
SELECT product_id, COUNT(order_id) total, unit_price
FROM order_items
WHERE unit_price>1000 AND COUNT(order_id)>5
GROUP BY product_id, unit_price;
Which statement is true regarding this SQL statement?
A.
The statement would execute and give you the desired result.
B.
The statement would not execute because the aggregate function is used in the WHERE
clause.
C.
The statement would not execute because the WHERE clause should have the OR logical
operator instead of AND.
D.
The statement would not execute because in the SELECT clause, the UNIT_PRICE column is
placed after the column having the aggregate function.