为另一列中的每个值选择不同的列然后分组依据

I am pretty new to mySQL and I have had a hard time over the past 2 days trying to get this to work. I do not know if the title is correct in relation on what I am trying to fix, but if it is not, please correct me.I am pretty new to mySQL and I have had a hard