skip to today's puzzle

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

namecategoryprice
Sconepastry3.25
Cookiepastry2.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 course

Ready 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