Which statement is true regarding this SQL statement?

View the Exhibit and examine the structure of the SALES table. The following query is
written to retrieve all those product IDs from the SALES table that have more than 55000
sold and have been ordered more than 10 times. Which statement is true regarding this
SQL statement?

A.
It produces an error because COUNT(*) should be only in the HAVING clause and not in
the WHERE clause.

B.
It executes successfully and generates the required result.

C.
It executes successfully but produces no result because COUNT(prod_id) should be
usedinstead of COUNT(*).

D.
It produces an error because COUNT(*) should be specified in the SELECT clause also.

Explanation: