Eine Einführung in
Usually we must have a GROUP BY clause if in aggregate function (such as SUM or COUNT) is used.
The exception is when only aggregate functions are used on the SELECT clause. If we mix aggregate and non-aggregate values then there must be a GROUP BY clause.
|Specific to MySQL|