The theory of grouping query results is similar to ordering and limiting query results concepts in that it uses a GROUP BY clause.  See sample format below;

ex.: 

    SELECT column(s)

    from table 

    Where clause 

    Group by column 

    Order by column LIMIT x

The grouping, aka or aggregate, functions are normally used with the Group By clause in a SQL query and below are the supported functions and as follows;