title: Find last 12 month + current month sale (my date format is string in mysql)
body: <pre><code>SELECT pd.DC_Date, SUM(pd.Quantity-pd.Credit_Quantity) AS 'Sales' 
  FROM past_year_data PD
  INNER JOIN idash_tb2_product_list PL ON PD.Product_Name = PL.Product_Name
  WHERE PD.Branch_Name = 'Delhi'
  AND DATE_FORMAT(STR_TO_DATE(DC_Date,'%m'), '%M') = DATE_FORMAT(STR_TO_DATE('7/31/2017', '%m'), '%M') 
  </code></pre>
  
  <p>This is what I am trying to do. </p>