title: SQL to get list of product name, sku and quantity sold in a year
body: <p>I want to get a full list of products sold in a year, grouped by Product Name or SKU.</p>
  
  <p>I have tried using the <em>Admin Reports > Products > ProductsOrdered</em> and selected the Time Frame. However this gives wrong Data, maybe because we have Bundled products and we sell lots of Bundle products.</p>
  
  <p>Any ideas on how this can be done by SQL?</p>
  
  <p>Edit :</p>
  
  <p>This is the current output, nothing wrong with the format but data given out is wrong.</p>
  
  <pre><code>---------------------------------------------------------------------------------
  |Period | Product Name                                       | Quantity Ordered |
  |-------|----------------------------------------------------|------------------|
  |2015   | std charge charge (Per Sofa)                       | 96               |
  |2015   | New Jersey 3 + 1 + 1 Seater Black Leather Sofa Set | 68               |
  |2015   | New Jersey 3 + 1 + 1 Seater Black Leather Sofa Set | 60 [ Repeated?]  |
  |2015   | Rex Black 3 + 2 GM200E                             | 52               |
  ..........
  </code></pre>