What does the following SQL statement do: SELECT Customer, COUNT(Order) FROM Sales GROUP BY Customer HAVING COUNT(Order) > 5

What does the following SQL statement do:
SELECT Customer, COUNT(Order)
FROM Sales
GROUP BY Customer
HAVING COUNT(Order) > 5 




A.Selects the total number of orders from the Sales table, if this number is greater than 5
B.Selects all Customers from the Sales table
C.Selects all customers from table Sales that have made more than 5 orders.
D.None of the other three



Answer: C


Learn More :