title: SQL,Trying to get the sum with a datetime column
body: <p>I have 2 columns, one is showing the email and the other one shows the date the email was created.</p>
  
  <p>What I'm trying to do is something like this:</p>
  
  <pre><code>registered customer     4     Date 01-01-2018
  registered customer     2     Date 01-02-2018   
  registered customer     9     Date 01-03-2018  
  </code></pre>
  
  <p>Any help would be appreciated.</p>
  
  <p>Thanks</p>