Filter results using WHERE and HAVING

Use BETWEEN to Filter Results

Use HAVING with Aggregate Functions

WHERE clause with NULLNOT NULL values

The WHERE clause only returns rows that match its criteria

Equality

AND and OR

Use IN to return rows with a value contained in a list

Use LIKE to find matching strings and substrings

Use HAVING to check for multiple conditions in a group

Where EXISTS