title: Delete Group of Records based on Group Statistic
body: <p>I have the following two example tables</p>
  <p>Teams</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Team ID</th>
  <th>Team Name</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>Bears</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Tigers</td>
  </tr>
  <tr>
  <td>3</td>
  <td>Lions</td>
  </tr>
  <tr>
  <td>4</td>
  <td>Sharks</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Players</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Player ID</th>
  <th style="text-align: left;">Name</th>
  <th>Team ID</th>
  <th>Playtime</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">1</td>
  <td style="text-align: left;">John</td>
  <td>1</td>
  <td>5</td>
  </tr>
  <tr>
  <td style="text-align: left;">2</td>
  <td style="text-align: left;">Adam</td>
  <td>1</td>
  <td>4</td>
  </tr>
  <tr>
  <td style="text-align: left;">3</td>
  <td style="text-align: left;">Smith</td>
  <td>1</td>
  <td>5</td>
  </tr>
  <tr>
  <td style="text-align: left;">4</td>
  <td style="text-align: left;">Michelle</td>
  <td>2</td>
  <td>5</td>
  </tr>
  <tr>
  <td style="text-align: left;">5</td>
  <td style="text-align: left;">Stephanie</td>
  <td>2</td>
  <td>10</td>
  </tr>
  <tr>
  <td style="text-align: left;">6</td>
  <td style="text-align: left;">David</td>
  <td>2</td>
  <td>10</td>
  </tr>
  <tr>
  <td style="text-align: left;">7</td>
  <td style="text-align: left;">Courtney</td>
  <td>2</td>
  <td>2</td>
  </tr>
  <tr>
  <td style="text-align: left;">8</td>
  <td style="text-align: left;">Frank</td>
  <td>2</td>
  <td>7</td>
  </tr>
  <tr>
  <td style="text-align: left;">9</td>
  <td style="text-align: left;">Teresa</td>
  <td>2</td>
  <td>1</td>
  </tr>
  <tr>
  <td style="text-align: left;">10</td>
  <td style="text-align: left;">Michael</td>
  <td>3</td>
  <td>3</td>
  </tr>
  <tr>
  <td style="text-align: left;">11</td>
  <td style="text-align: left;">May</td>
  <td>4</td>
  <td>1</td>
  </tr>
  <tr>
  <td style="text-align: left;">12</td>
  <td style="text-align: left;">Daniel</td>
  <td>4</td>
  <td>1</td>
  </tr>
  <tr>
  <td style="text-align: left;">13</td>
  <td style="text-align: left;">Lisa</td>
  <td>4</td>
  <td>4</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I need a select statement with the following criteria</p>
  <ul>
  <li>Select all teams with less than 4 players</li>
  <li>Figure out the total playtime for all players on those teams and sort the resulting table based on this in descending order</li>
  </ul>
  <p>Based on the example given, I would want a table that looks like this:</p>
  <p>Teams</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Team Name</th>
  <th>Num Players</th>
  <th>Total Playtime</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Bears</td>
  <td>3</td>
  <td>14</td>
  </tr>
  <tr>
  <td>Sharks</td>
  <td>3</td>
  <td>6</td>
  </tr>
  <tr>
  <td>Lions</td>
  <td>1</td>
  <td>3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Finally, I want to cut all even rows from the previous table, so the final table would look like:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Team Name</th>
  <th>Num Players</th>
  <th>Total Playtime</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Bears</td>
  <td>3</td>
  <td>14</td>
  </tr>
  <tr>
  <td>Lions</td>
  <td>1</td>
  <td>3</td>
  </tr>
  </tbody>
  </table>
  </div>