bit late......
SELECT DATEPART(mm, OrderDate) AS MonthNum, AVG(orderCount) AS AvgOrderCount
FROM OrderTest
GROUP BY DATEPART(mm, OrderDate), DATEADD(mm, DATEDIFF(mm, 0, OrderDate), 0)
ORDER BY DATEADD(mm, DATEDIFF(mm, 0, OrderDate), 0) DESC
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day