MySQL Wizardry : Cross Tabulation

"The way I found [the solution] is littered with errors and disappointment, and in perspective it should appear quite boring. This is the chronicle of how I would have liked to find out a solution."

meta