EasyOutput prediction
COUNT with WHERE
Given this table (orders):
| id | customer | status |
|---|---|---|
| 1 | Alice | shipped |
| 2 | Bob | pending |
| 3 | Alice | shipped |
| 4 | Alice | pending |
What does this query return?
SELECT COUNT(*) FROM orders WHERE customer = 'Alice' AND status = 'shipped';
← → arrow keys to navigate
Sign in to save your progress.