Android - How to combine rows based on duplicate data in Sqlite

Hi I have something like this in my database -

Now I need to write a query that gives me the following result -

Any help would be really appreciated.