Multiple Conditions with AND/OR

Combine conditions with AND and OR.

AND - both conditions must be true:

WHERE salary > 80000 AND department_id = 1

OR - at least one condition must be true:

WHERE department_id = 1 OR department_id = 2

You can combine them (use parentheses for clarity):

WHERE (department_id = 1 OR department_id = 2)
AND salary > 80000