The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

The HAVING and WHERE clauses are interchangeable.

HAVING clause can only be used if the SELECT query has GROUP BY clause.

With GROUP BY, the select-list of the SELECT statement can only take the group-field and/or aggregate function.