SQL Grouping keywords

G

GROUP BY

The SQL GROUP BY clause groups rows that share the same values.

H

HAVING

The SQL HAVING clause filters aggregated results after GROUP BY.