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?
View The Exhibi 1 (15.49 KiB) Viewed 434 times
View The Exhibi 2 (40.6 KiB) Viewed 434 times
A. It executes successfully and generates the required result.
B. It produces an error because COUNT(*) should be specified in the SELECT clause also.
C. It produces an error because COUNT(*) should be only in the HAVING clause and not in the WHERE clause.
D. It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*).
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!