IN and BETWEEN

category IN ('accessories', 'stationery') is shorthand for a chain of OR equalities. price BETWEEN 10 AND 40 is shorthand for price >= 10 AND price <= 40; both ends are included. Both read better than the long form and both can be negated: NOT IN, NOT BETWEEN.

IN also accepts a subquery instead of a fixed list, which becomes powerful once you reach the joins module.

SELECT name FROM employees WHERE dept IN ('Sales', 'Support') AND salary BETWEEN 4500 AND 5500;

Your task

Show the name and price of products in the accessories or stationery categories that cost between 10 and 40 inclusive.

SELECT name, price FROM products WHERE category IN ('accessories', 'stationery') AND price BETWEEN 10 AND 40;