Query monthly sales displayed by month

Hello,

i am looking for a Query that will show all of our items and the amount sold in orders displaying the result by month.

I would also like to know the stock at the time of using the query and the minimum stock if there is.

So, header would be...

Item #...Jan Qty...Feb Qty...Mar Qty...etc... In Stock... Minimum stock

Does anyone know a Query that can do this?

Thanks!

Virginia