How to Query & re-organize Data from current MySQL database?

I have the following database structure:

Database Structure

And the data stored inside is as follows:



However, I like to select data from this database in the following format:
What I Want

How can I use one single SELECT statement to achieve this? If using one single SELECT statement cannot, how to achieve this by whatever sql code? Can someone give me the implementation?

Source: sql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.