Question

Consider a table Orders with columns OrderID, CustomerID, OrderDate, and TotalAmount. Which SQL query would correctly find the total number of orders and the average TotalAmount for each CustomerID who has placed more than 5 orders? Option

Q: Answer-Consider a table Orders with columns OrderID, CustomerID, OrderDate, and TotalAmount. Which SQL quer...

SELECT CustomerID, COUNTOrderID, AVGTotalAmount FROM Orders GROUP BY CustomerID HAVING COUNTOrderID 5 Explanation The WHERE clause is used to filter individual rows before grouping, and it cannot contain aggregate functions. The HAVING clause is used to filter groups after the GROUP BY clause has been applied, and it can use aggregate functions. The correct order of execution in a SELECT statement is FROM, JOIN, WHERE, GROUP BY, HAVING, SELECT, ORDER BY. Therefore, to filter groups based on an aggregate condition COUNTOrderID 5, the HAVING clause must be used after GROUP BY.