# Mysql – SELECT , GROUP AND DISPLAY IN TABULAR FORM

MySQL

I Have a table as above. How can I get an output (as shown below) with a single mysql query.

SELECT location,