There are many situations that require aggregation functions $($e$.$g$.$ Sum, Count, AVG, etc.$)$ calculations to be made on several different groups of rows. This is a job for the

$$ clause.

WHERE

ORDER BY

GROUP BY

HAVING