title: SQL - monthly average rather than daily average
body: <p>I have a table called values that contains 3 columns - Location, value, date</p>
  
  <p>I want to work out the average value per month </p>
  
  <p>so far I have </p>
  
  <pre><code>SELECT Location, Avg(value), date  
  FROM Value  
  GROUP BY Location, date 
  </code></pre>
  
  <p>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?</p>