title: SQL Runnnig the same Query multiple times
body: <p>I have a query that gives me the COUNT between two dates, start_date &amp; end_date and is grouped by various columns. 
  Is there any way I can get the COUNT for each day ? As in say start_date is date1 and end_date is date5, so I need to run the query once for 'date1 to date2', the 'date1 to date3', then 'date1 to date4', then 'date1 to date5'. As in running the same query multiple times based on the start &amp; the end dates ?
  My query looks like </p>
  
  <pre><code>Select COUNT(A), B, C, D
  FROM TABLE 
  WHERE CONDITION1 AND DATE BETWEEN start_date AND end_date
  GROUP BY B, C, D
  </code></pre>