The GROUP BY clause is used to specify a set of columns
which are used to arrange the rows of the result into groups. All
rows which are equivalent for each column specified in the
GROUP BY clause are grouped together and treated as a
single row in the output.
The SELECT can specify expressions involving grouped
columns and aggregate expressions involving non-grouped columns in
the result.
