Filtering Groups1 / 3
EASY·Output prediction
Given this table (orders): | id | customer | |----|----------| | 1 | Alice | | 2 | Bob | | 3 | Alice | | 4 | Carol | | 5 | Alice | What does this query return?
SELECT customer, COUNT(*) AS order_count FROM orders GROUP BY customer HAVING COUNT(*) >= 2;
Sign in to save your progress.