Sharper filters · AND, OR and IN
Combining conditions
AND needs both conditions to be true; OR needs either. AND is evaluated before OR, so use parentheses when you mix them.
IN (...) is a tidy way to write several ORs on one column, and BETWEEN a AND b includes both ends.
Go deeper: SQL WHERE: filtering rows
Try it
SELECT name, species FROM pets
WHERE species IN ('rabbit', 'bird') AND age < 3;Press Enter to continue