SELECT SUM(TotalPrice) AS [TotalPrice], COUNT(OrderID) AS [Sales], MONTH([Date]) AS [Month], YEAR([Date]) AS [Year]
FROM [Order]
WHERE OrderStatusID = 4 -- Complete
GROUP BY Month([Date]), YEAR([Date])
I just wrote that, nice and simple and it tells me how much ive made for each month of each year
