title: how do i count the number of data in a column for each month using a start and end date
body: <p>I have a table with similar information and i want to extract the data like this when a user selects a start date '2015-01-22' and end date '2015-07-31' . 
  The result should look like this.</p>
  
  <pre><code>Month        Total Quantity    
  January: 8
  February: 6
  March: 0
  April: 0
  May: 2
  June: 18
  July: 6
  </code></pre>
  
  <p>Here's a sample query and fiddle </p>
  
  <pre><code>CREATE TABLE orders
  (
    id INT PRIMARY KEY AUTO_INCREMENT,
    order_date DATE,
    product_id INT,
    quantity INT,
    customer_id INT
  );
  INSERT INTO orders (order_date, product_id, quantity, customer_id)
    VALUES
    ('2015-01-01', 1, 2, 123),
    ('2015-01-06', 3, 6, 123),
    ('2015-02-14', 2, 4, 123),
    ('2015-02-15', 2, 2, 123),
    ('2015-05-16', 1, 1, 456),
    ('2015-05-17', 1, 1, 456),
    ('2015-06-18', 1, 5, 789),
    ('2015-06-18', 3, 7, 123),
    ('2015-06-10', 3, 6, 123),
    ('2015-07-13', 1, 5, 456),
    ('2015-07-14', 1, 1, 456);
  </code></pre>
  
  <p><a href="http://sqlfiddle.com/#!2/01ac19/1" rel="nofollow">http://sqlfiddle.com/#!2/01ac19/1</a></p>
  
  <p>The results should be the total number of quantity of Orders per month</p>