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 not execute because in the SELECT clause, the UNIT_PRICE
column is placed after the column having the aggregate function.
B.
The statement would not execute because the WHERE clause should have the OR
logical operator instead of AND.
C.
The statement would execute and give you the desired result.
D.
The statement would not execute because the aggregate function is used in the WHERE
clause.