title: Average temperature by day of year with SQLite DDB
body: <p>I'm looking for a good solution to show the average temperature day by day of the year from a SQLite Database.</p>
  
  <p>In my database, to be sample, I have a date column and a temp column, for each day since 5 years like that.</p>
  
  <p><a href="https://i.stack.imgur.com/oH6YH.png" rel="nofollow noreferrer">example</a></p>
  
  <p>I would like to get, for each day of the year, the average temperature from my database.
  I found the request to calculate the average for one day, but I don't how can I do like that for each day</p>
  
  <pre><code>SELECT avg(min) FROM historique WHERE strftime('%m-%d', date )= "04-01";
  </code></pre>
  
  <p>Could you help me please ?</p>