Glossary: SQL Basics

WHERE

A clause that keeps only the rows for which a condition is true. It runs before grouping, so it can't test aggregates.