title: SQL get count of value
body: <p>I have the following table. Now I want to count the amount of each value in this table.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>value</th>
  <th>count</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>1</td>
  </tr>
  <tr>
  <td>-1</td>
  <td>1</td>
  </tr>
  <tr>
  <td>2</td>
  <td>1</td>
  </tr>
  <tr>
  <td>3</td>
  <td>1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>-1 and 1 should be seen as 1, so the output should be</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>value</th>
  <th>count</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>2</td>
  </tr>
  <tr>
  <td>2</td>
  <td>1</td>
  </tr>
  <tr>
  <td>3</td>
  <td>1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Does someone know a quick fix?</p>