WHERE filters rows before any grouping: only those whose condition is true are kept. Conditions use comparison operators (=, <>, <, >) and logical operators. A condition that evaluates to NULL is treated as false.
Example
SELECT * FROM clients WHERE pays = 'FR';