MySQL show data from Rows to columns
Finally I got the answer. Below is the fiddle.

sqlfiddle.com/#!9/83f530/6 or sqlfiddle.com/#!9/83f530/7 

Thanks to Akina who helped me a lot. I will prefer to use single join SQL over multiple join fiddle.