I have a Daily Production table and I want to Average it by the month. If I have production from 1/1/2018 thru 11/30/2018 on a daily basis. Give me the average production for January 2018, February 2018, March 2018 and so on. Please help I have tried everything.
SELECT
[Year] = DATEPART(YEAR, ProductionDate),
[Month] = DATEPART(MONTH,ProductionDate),
AverageMonthlyProduction = AVG(DailyProduction * 1.0)
FROM
YourTable
GROUP BY
DATEPART(YEAR, ProductionDate),
DATEPART(MONTH,ProductionDate)