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;