Pivot in SQLite for android studio

Good day. Can someone help with this please?

I have query like this http://ift.tt/1TcLOB6

and I want to have an output like this http://ift.tt/1WYmMUw

Thank you.