title: Create a report show specific stats for each day between a start and end date
body: <p>I have a table with that contains information that I would like to show stats for each day between a particular range of dates.  The table consists of the following:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `questions` (
    `qid` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `question_created_date` datetime NOT NULL,
    `question_response_date` datetime NOT NULL,
  )
  </code></pre>
  
  <p>I am able to use the following query to displays the amount of questions created on each day between $start_date and $end_date.</p>
  
  <pre><code>SELECT COUNT(*) as q_count, DATE(question_created_date) as date FROM questions where question_created_date between "$start_date" and "$end_date" GROUP BY date ORDER BY date asc
  </code></pre>
  
  <p>I would also like for it to list the amount of topics that were responded to on the same days. For exmaple if on 7/5/11 there were 10 new questions and 5 questions responded to and on 7/6/11 there were 5 new questions and 11 questions responded to, I want to be able to show:</p>
  
  <pre><code>Date|New|Responded
  
  7/5/11 10 05
  7/6/11 05 11
  </code></pre>
  
  <p>Can this be done via mysql?</p>
  
  <p>I know I can perform the query listed above and then for each day perform another query to get the amount of questions responded to for that day, but I was wondering if there was an easier and more efficient way to do this in one query.</p>
  
  <p>Thanks in advance.</p>