title: Listing products sold within a date range and order them by quantity sold
body: <p>The task is: List the products according to the quantity they were sold in winter from less to many.</p>
  <p>I have data like below.</p>
  <h3>Products</h3>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;"><em>product_code</em></th>
  <th style="text-align: left;"><em>product_name</em></th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">3334</td>
  <td style="text-align: left;">AAA</td>
  </tr>
  <tr>
  <td style="text-align: left;">8388</td>
  <td style="text-align: left;">BBB</td>
  </tr>
  </tbody>
  </table>
  </div><h3>Sales</h3>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;"><em>sales_code</em></th>
  <th style="text-align: left;"><em>product_code</em></th>
  <th style="text-align: right;">sales_date</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">5577</td>
  <td style="text-align: left;">3334</td>
  <td style="text-align: right;">25-12-2019 12:29</td>
  </tr>
  <tr>
  <td style="text-align: left;">5578</td>
  <td style="text-align: left;">8388</td>
  <td style="text-align: right;">14-03-2020 13:30</td>
  </tr>
  </tbody>
  </table>
  </div><h3>Desired Result</h3>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;"><em>produ_code</em></th>
  <th style="text-align: left;"><em>product_name</em></th>
  <th style="text-align: right;">Quantity</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">3334</td>
  <td style="text-align: left;">AAA</td>
  <td style="text-align: right;">55</td>
  </tr>
  <tr>
  <td style="text-align: left;">8388</td>
  <td style="text-align: left;">BBB</td>
  <td style="text-align: right;">97</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>We know that the winter months are December, January, and February. According to the dates I have to find quantity.</p>
  <p>I don't know how to start but</p>
  <pre><code>(WHERE sales.sales_date
     AND sales.sales_date BETWEEN '01-12- 00:00:00' AND '28-02- 00:00:00'
   GROUP 
      BY sales_products.products_id) 
  </code></pre>
  <p>Can you help?</p>