title: Is there a way to get how many rows are in my table for each month of the year?
body: <p>I would like to work out how many user sign ups i have gotten in each month. I've got a <code>users</code> table which contains a <code>signUpDate</code> of type <code>varchar</code> in dd/mm/yyyy format.</p>
  <p>I've written a select statement which gets how many sign ups I have gotten this month:</p>
  <pre><code>select COUNT(*) as numberOfSignUps from users WHERE STR_TO_DATE(signupDate,'%d/%m/%Y') &gt;= STR_TO_DATE('31/05/2020','%d/%m/%Y')  AND STR_TO_DATE(signupDate,'%d/%m/%Y') &lt;= STR_TO_DATE('30/06/2020','%d/%m/%Y'); 
  </code></pre>
  <p>This works fine but is there a way to go back through all previous months without manually adding the dates?</p>
  <p>The desired result would be columns of the months with the number of sign ups for each.</p>