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.

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.

29. What is the result of the following SQL Query? SELECT COUNT(*), AVG(amount) FROM Orders WHERE amount > 200; Number of orders with amount > 200 and the average amount of these orders.Total number of orders and the average amount of all orders.Number of customers with orders > 200 and the average order amount per customer.Total number of orders > 200 and the average number of orders.

Which SQL function can be used to count the number of rows in a GROUP BY clause?COUNT()SUM()AVG() MAX()

Question 7: (1.00) When you use the GROUP BY clause without applying an aggregate function, it works like… the LIMIT clause the HAVING clause the DISTINCT clause the ORDER BY clause the JOIN clause

Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.Where, havingHaving, whereGroup by, havingGroup by, where