EasyOutput prediction
HAVING with COUNT
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;
← → arrow keys to navigate
Sign in to save your progress.