CASE statement MySQL

How to create a MySQL Pivot Table