WHERE clause and GROUP BY

You can use a WHERE clause in a statement with GROUP BY. The WHERE clause is evaluated before the GROUP BY clause. Rows that
do not satisfy the conditions in the WHERE clause are eliminated before any grouping is done. Here is an example: