1. I need a similar analysis for customers in the top two categories. I need a ranked list of the top five customers in the top categories for each of the last five months, use the dollar amount purchased per month to rank customers in each category. I also need to know which customers were in the top five for more than one month (how often and what rank). Specifically, I would like to know which customers, if any, were in the top 5 for all five months for either category.
2. Most importantly, since we do not know what else the committee may want to know, please create a flexible tool that can provide me the ability to look at customer and category sales information in other ways (you can assume that I am pretty proficient in using excel pivot tables and should include such a tool).

I am having trouble finding the SQL query for these two questions.