This looks easy enough to solve given a bit more information.

Can you post the queries that gave the results above, and if you posted some sample data you would most likely get a solution straight away.