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: SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*)>10 GROUP BY prod_id HAVING COUNT(*)>10; Which statement is true regarding this SQL statement? Select one:a.It produces an error because COUNT (*) should be specified the SELECT clause also.b.It executes successfully and generates the required result.c.It executes successfully but produces no result because COUNT(prod_id) should be used instead of COUNT(*) .d.It produces an error because COUNT (*) should be only in the HAVING clause and not in the WHERE clause.

Question 3Which HAVING clause indicates to only retrieve products that have been sold more than 100 times?1 pointHAVING COUNT(order_items.product_id) > 100HAVING COUNT(order_items.product_id) < 100HAVING (order_items.product_id) > 100HAVING (order_items.product_id > 100)

tblProducts Table ProductID   SupplierID   CategoryID   ProductName 1 1 1 Chai2 1 1 Chang3 1 2 Aniseed Syrup4 2 2 Chef Anto's Cajun Using the tblProducts Table shown above, which of the following SQL statements returns the total number of products that come from SupplierID=1 in the tblProducts table?Question 8Select one:a.Select * From tblProducts Count(*);b.Select  Count(*) from tblProducts;c.Select  Count(*) from tblProducts Where SupplierID=1;d.Count(*) tblProducts;

SELECT lot_no "Lot Number", COUNT(*) "Number of Cars Available"FROM carsWHERE model = 'Fire'GROUP BY lot_noHAVING COUNT(*) > 10ORDER BY COUNT(*);In the above statement which clause restricts which groups are displayed?Select one:a.SELECT lot_no "Lot Number", COUNT(*) "Number of Cars Available"b.GROUP BY lot_noc.HAVING COUNT(*) > 10d.WHERE model = 'Fire'e.ORDER BY COUNT(*)

SELECT cust_city, COUNT(cust_last_name) FROM customersWHERE cust_credit_limit > 1000 GROUP BY cust_city HAVING AVG(cust_credit_limit) BETWEEN 5000 AND 6000;Which statement is true regarding the outcome of the above query? Select one:a.It executes successfully.b.It returns an error because WHERE and HAVING clauses cannot be used in the same SELECT statement.c.It returns an error because the BETWEEN operator cannot be used in the HAVING clause.d.It returns an error because WHERE and HAVING clauses cannot be used to apply conditions on the same column. e.Date functions

Consider the following SQL query: SELECT customer_id, MAX(total_amount) AS max_amount FROM Orders GROUP BY customer_id HAVING COUNT(*) > 1;What will be the output of this query?OptionsThe customer IDs and the maximum order amount for customers who have placed more than one order.The customer IDs and the average order amount for customers who have placed more than one order.An error because the HAVING clause is used without an aggregate function in the SELECT clause. An error because the GROUP BY clause is not properly used.