MySQL aggregate functions

How to create a MySQL Pivot Table