AND means both tests must pass
AND combines two tests, and a row appears in your results only if it passes both. Each side must be a complete test with its own column name. Every extra AND narrows the result, because each row has more conditions to satisfy.
A tiny example
In plain English: Show me the pastries that cost less than 5.
SELECT name, category, price
FROM menu_items
WHERE category = 'pastry'
AND price < 5;Query result
| name | category | price |
|---|---|---|
| Scone | pastry | 3.25 |
| Cookie | pastry | 2.5 |
Scone and cookie are the only menu items that pass both tests: pastry category and price under 5.
Related SQL lessons
Practice AND step by step
The Foundations Track has beginner puzzles built around this idea. Tap tiles, see real results. No terminal, no setup.
practice this in the courseReady for a break?
A fresh, bite-sized SQL puzzle waits every morning. Tap tiles, see real results. No terminal, no setup, no timers.
Try today's free SQL puzzle