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:

test_summary

test_details

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