How to create a matrix out of two columns?
Posted: Fri 08 May 2020 06:19
I have one table with student registrations containing the student's school name and class. I would like to "explode" this data into a matrix with one row per school and as many columns as there are classes (10). Is this possible with MySQL, or do I need to make a query grouped by classes for each school?