EasyOutput prediction
Basic HAVING clause
Given this table (orders):
| id | customer | amount |
|---|---|---|
| 1 | Alice | 100 |
| 2 | Bob | 200 |
| 3 | Alice | 300 |
| 4 | Bob | 50 |
What does this query return?
SELECT customer, SUM(amount) AS total FROM orders GROUP BY customer HAVING SUM(amount) > 300;
← → arrow keys to navigate
Sign in to save your progress.