GROUP BY

GROUP BY allows users to apply other aggregate functions to sub-sets of the set of entities matching the query.  This

This is the fundamental building block for analysing information by Type, Status, Priority etc.

...