AGGREGATE FUNCTIONS:  SYNTAX

 

            SELECT column list, function(), function(), ...

            FROM table1

                INNER JOIN table2

                ...

                ON

                ...

            WHERE criteria for row selection

            GROUP BY column list

            HAVING criteria for function results

            ORDER BY column list