GoogleSearch: mysql pivot query
MySQL Multi-Aggregated Rows in Crosstab Queries
MySQL Wizardry
MySQL/Pivot table (wikibooks)