MySQL pivot example

How to create a MySQL Pivot Table