What does this following query do? SELECT customer_id, COUNT (orders)

FROM Sales

GROUP BY customer_id

HAVING COUNT (orders) 5;

Question

What does this following query do? SELECT  customer_id,  COUNT  (orders)

FROM  Sales

GROUP   BY  customer_id

HAVING COUNT (orders) >5;

Answer

B.  Select all the customer from
the table Sales

Answer

A.  Select all the customers
from the table Sales who had bought more than 5 orders

Answer

C.  Select the total number of
orders from the table Sales, if this number is larger than 5

Crowdly