AND
A logical operator that is true only if all of its conditions hold. AND binds tighter than OR, so brackets are only needed when you mean the OR to be evaluated first.
SELECT title FROM film
WHERE length > 100 AND rating = 'PG';
When to use
Used in WHERE conditions such as the reading's length > 100 AND rating = 'PG', and in the BETWEEN example length BETWEEN 90 AND 120, where the AND is part of BETWEEN itself.
See Read 01.