Beginner
Case 1 of 50
Case 001: Finding Nina
customers
Alex just joined ByteMart as a junior data analyst.
On day one, the manager hands over the company database and a very simple first job: "A customer named Nina called in — pull up her record."
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 the customer named Nina in the customers table.”
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 name = 'Nina';
What that query returns
Case Debrief
SELECT, FROM, WHERE
- SELECT picks the columns you want, FROM picks the table, WHERE filters the rows down to the ones that match.