title: Count total number of multiple line items in MySQL
body: <p>I'm new to MySQL. Not sure how to Google it though for info to get started. </p>
  
  <p>I have a table called "Questions_Asked". It has a list of all the questions asked about an item. So my data looks like this: </p>
  
  <pre><code>id  asker_id    item_in_question_id created_at  updated_at 
  115199   NULL                  NULL         1/31/13 21:43   1/31/13 21:43 
  23487    18189                 2870         10/25/11 18:25  10/25/11 18:25 
  24400    21386                 2900         11/9/11 16:09   11/9/11 16:09 
  24870    25243                 2900         11/15/11 14:43  11/15/11 14:43 
  </code></pre>
  
  <p>Basically I need a count of all the items with multiple questions. So in this case, item 2900 has 2 questions asked. </p>
  
  <p>I know this probably involves a sub-query and grouping, but I can't seem to wrap my head around it being brand new to it. </p>
  
  <p>I should also add that I need to be able to pull this based on a vague criteria. So while I can pull it if I specifically run the query for, "WHERE item_in_question_id = 2900;", I need to be able to run a query where the created_at falls between a certain range and then I can just do a "SELECT id, created_at, updated_at, COUNT xxxx AS Askers" etc. </p>