Beginner
Case 8 of 50
Case 008: The Preferred Regions
customers
A regional promotion is launching.
"It's only live in Germany, Japan, and Australia for now," the manager says. "Could you pull the customer list for those three?"
The data Alex is looking at
customers
| id | name | country |
|---|---|---|
| 1 | Sam | Germany |
| 2 | Nina | Canada |
| 3 | David | Brazil |
| 4 | Maya | Japan |
| 5 | Daniel | Australia |
| … 1 more row | ||
TASK
Help Alex answer the manager:
“Find every customer based in Germany, Japan, or Australia.”
Write a query above and hit Run to see what comes back.
No hints requested yet — click "Get a hint" when you're stuck.
Alex's final query — this is for reference. Copy it into your own thinking, not into the editor above.
SELECT *
FROM customers
WHERE country IN ('Germany', 'Japan', 'Australia');
What that query returns
Case Debrief
IN with a literal list
- IN (value1, value2, ...) checks a column against multiple exact values in one clean condition — much shorter than writing a separate equality check for each one.