Values Not Being Defined When Outputted In Python Mysql?

Aided by a previously asked question see (How to correctly convert SQL rows to columns?), I'm attempting to apply to a MySQL connector script written in python. As seen by @Popeye

Solution 1:

You have used wrong names.(in case expression names are used without space. You should use it exactly same as per val)

Replace

max(casewhen name ='PersonA'then A end) as PersonA

With

max(casewhen name ='Person A'then A end) as PersonA

See the space between Person and A in name. Do the same for Person B and Person C