You have been hired as a Data Analyst for the Cycle to the Mood company. For your first task you have been given a set of questions to answer based on the BikeStores DB.

- What was the most popular product each year? And what month has the highest sales.

- Return the most profitable staff at each store. And return the total amount of order as well as the number of orders placed for each of those staff.

- What is the most popular product in each brand and for each of those products return the customer who ordered the most.

- Are there any orders that havent been shipped yet? If yes I need to know the inventory for them and see if we need to re-order

Keep in mind that you may need to run multiple queries for each. In that case you can create temporary tables to combine the data from multiple queries. For each question you need to explain your strategy and how you want to solve it. Feel free to add comments throughout your script to convey your thoughts.