title: I need to sum values with specific condition
body: <p>I have table like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Id</th>
  <th style="text-align: center;">km</th>
  <th style="text-align: right;">date</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">1</td>
  <td style="text-align: center;">5</td>
  <td style="text-align: right;">20-5-2020</td>
  </tr>
  <tr>
  <td style="text-align: left;">1</td>
  <td style="text-align: center;">9</td>
  <td style="text-align: right;">20-5-2020</td>
  </tr>
  <tr>
  <td style="text-align: left;">3</td>
  <td style="text-align: center;">7</td>
  <td style="text-align: right;">20-5-2020</td>
  </tr>
  <tr>
  <td style="text-align: left;">1</td>
  <td style="text-align: center;">4</td>
  <td style="text-align: right;">10-5-2020</td>
  </tr>
  <tr>
  <td style="text-align: left;">3</td>
  <td style="text-align: center;">2</td>
  <td style="text-align: right;">10_5_2020</td>
  </tr>
  <tr>
  <td style="text-align: left;">4</td>
  <td style="text-align: center;">9</td>
  <td style="text-align: right;">10_5_2020</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>What i need is to sum the km for each id in the month, I want the result like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Id</th>
  <th style="text-align: center;">km 20 may</th>
  <th style="text-align: right;">km 10 may</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">1</td>
  <td style="text-align: center;">14</td>
  <td style="text-align: right;">4</td>
  </tr>
  <tr>
  <td style="text-align: left;">3</td>
  <td style="text-align: center;">7</td>
  <td style="text-align: right;">2</td>
  </tr>
  <tr>
  <td style="text-align: left;">4</td>
  <td style="text-align: center;">0</td>
  <td style="text-align: right;">9</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I tried this code and didn't get the result that I want</p>
  <pre><code>Select id, 
  sum(select km from info where date =='10_5_2020') as 'km 10 may',
  Sum(select km from unfo where date == '20-5-2020') as 'km 20 may'
  From info
  </code></pre>