SQL - monthly average rather than daily average

Question

I have a table called values that contains 3 columns - Location, value, date

I want to work out the average value per month

so far I have

SELECT Location, Avg(value), date  
FROM Value  
GROUP BY Location, date 

This returns the average values but a value is entered on a daily basis so I have an average per day rather than per month, how can I achieve a monthly average?

Answer 1

try this:

SELECT    Location,
          Avg(value),
          month(date),
          year(date)
FROM      Value
GROUP BY  Location,
          month(date),
          year(date)