title: One query to get total # records for each day in a month
body: <p>Scenario:</p>
  
  <p>I have a table of registrations and there is a datetime column.</p>
  
  <p>I want to display a bar graph on a webpage showing number of registrations per day for the current month.</p>
  
  <p>How can I do that with one query? i.e. get back a resultset with a field for each day (of current month) with the total number of registrations that day</p>