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)

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.

What will be the result of the following query? SELECT customer_id, AVG(total_amount) AS avg_amount FROM Orders GROUP BY customer_id HAVING AVG(total_amount) > 200;OptionsReturns the customer IDs and average order amounts for all customers.Returns the customer IDs and average order amounts for customers with an average order amount greater than 200.Returns the customer IDs and total order amounts for customers with an average order amount greater than 200.Returns an error because the HAVING clause is not allowed in this context.

Write a query to retrieve the seller ID(s) who made the highest total sales based on the total sum of prices for all their sales.Table: Productproduct_id is the primary key of this table. Each row of this table indicates the name and the price of each product. Table: SalesThis table has no primary key, it can have repeated rows. product_id is a foreign key to the Product table.

Write a query to retrieve the names of customers who have made multiple purchases and the count of their purchases.Table: OrdersNote: Tables and values are prepopulated.Alias Name: NumberofProducts

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.