Combining Conditions with AND

One condition is often not enough. A parent is looking for a game for their 7-year-old, and it should cost less than $20. Join the two conditions with AND:

SELECT title, age_rating, price
FROM games
WHERE age_rating <= 7
  AND price < 20
ORDER BY price, title;

A row gets into the result only when both conditions are true for it. Cube Logic is suitable from the age of 3 and costs $5: both conditions are true, so it's in. Goal Rush is suitable from 3 too, but it costs $50: the second condition is false, so it's left out.

You can join as many conditions as you need, and a row must meet all of them. Put each condition on its own line, with AND at the start, and even a long condition is easy to read. The adventure games for 12-year-olds for $20 at most:

SELECT title, age_rating, price
FROM games
WHERE genre = 'Adventure'
  AND age_rating <= 12
  AND price <= 20
ORDER BY title;

A range of values, such as the prices from $10 to $20, is two conditions joined with AND too: price >= 10 AND price <= 20. (A shorter way is coming later in this lesson.)

Typical mistake: WHERE price >= 10 AND <= 20. You'd say “a price of at least 10 and at most 20”, but in SQL, each condition must be complete on its own. The second one here has no column, and SQLite reports:

Error on line 1: near "<=": syntax error

Write the column in each condition: price >= 10 AND price <= 20.