simple php mysql data display

I have 2 tables in a database 1 includes posts that include city/category/date the other includes responses that include city/category/date what i need is to display the total responses for the last month per city in each category and overall and also average responses per post in each city overall and also each cityies category this should be organized nicely in a table