title: Mysql get weekly average of daily data
body: <p>I have a table called primeWeek. Im trying to get weekly avg depends on dates.</p>
  <p>Example of my table</p>
  <pre><code>id | count | date
  1  |  70   | 2020-08-29
  2  |  67   | 2020-08-30
  3  |  69   | 2020-08-31
  4  |  82   | 2020-09-01
  5  |  73   | 2020-09-02
  </code></pre>
  <p>I tried few things but results are not correct.</p>