• That answer's not 100% accurate.

    All nonaggregated columns in the SELECT clause must also be listed in the GROUP BY clause; assuming that there is at least one aggregated column in the SELECT or HAVING clauses.

    You don't need to specify a GROUP BY clause if there are no aggregates in your SELECT or HAVING clauses.

    But that's just being nitpicky.