Your requirements are lacking, you need to post the following:

1) Provide a working test case with create table/insert statements.
2) Provide proper requirements to generate the output you expect.
3) A sample output based on the data you will provide.