Expand your MySQL SELECT statements with aggregate functions.

This will be a demo-filled session covering the common SQL aggregate functions: COUNT(), MIN(), MAX(), AVG() and SUM() and how GROUP BY affects the results.  Also covered is the differences between the filter clauses WHERE and HAVING in relation to aggregate and non-aggregate fields.