Summary - Operators

Combine arithmetic, comparison and logical operators in one query.

In this group you learned arithmetic, logical, comparison, NULL and range/list operators. Combine them to write complex conditions.

SELECT name FROM products
WHERE (price > 10 OR category = 'kitap')
  AND stock IS NOT NULL;

This query products with price over 10 or category book, and stock not null.

name is selected from products. WHERE keeps only the rows where (price > 10 OR category = 'kitap') AND stock IS NOT NULL holds.

Exercise Summary - Operators

Select names from products where price > 10 AND stock > 0.

Show example solution

SELECT name
FROM products
WHERE price > 10 AND stock > 0