Summary - WHERE filtering

Combine comparison, logical and pattern operators to filter rows.

In this group you learned WHERE filtering: comparison operators, AND/OR, IN/BETWEEN and LIKE patterns. Now you will combine these in one query.

SELECT name, price
FROM products
WHERE category = 'kitap' AND price < 50;

This returns products whose category is book and price is below 50.

name, price is selected from products. WHERE keeps only the rows where category = 'kitap' AND price < 50 holds.

Exercise Summary - WHERE filtering

Select name and price from products where category is 'book' AND price is less than 50.

Show example solution

SELECT name, price
FROM products
WHERE category = 'kitap' AND price < 50

Next lesson: ORDER BY