title: PostgreSQL: how do build a table with an ever-increasing daily total?
body: <p>Assuming this data:</p>
  <pre><code>ID    DATE
  44    2019-12-31
  45    2020-01-01
  46    2020-01-01
  47    2020-01-02
  48    2020-01-03
  48    2020-01-03
  48    2020-01-03
  
  </code></pre>
  <p>How do I make a query that returns something like this?</p>
  <pre><code>TOTAL     DATE
  2         2020-01-01
  3         2020-01-02
  6         2020-01-03
  </code></pre>
  <p>I want all entries after a certain data, but with a counter that starts with the number of entries on the first day, then for every day, it adds the number of entries on that day. I want to plot them on a chart that shows the speed of the growth.</p>
  <p>Is this possible? I'm on PostgreSQL 10.</p>
  <p>Thanks!</p>