View the Exhibit and examine the structure of the SALES table.The following query is written to retrieve all those produ
Posted: Wed Jun 07, 2023 6:12 am
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 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(*).
- View The Exhibi 1 (15.49 KiB) Viewed 155 times
- View The Exhibi 2 (40.6 KiB) Viewed 155 times
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(*).