title: Select Rows with min value for each group
body: <p>I have a database with a table that look like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Date</th>
  <th>Container ID</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1/1</td>
  <td>1</td>
  </tr>
  <tr>
  <td>2/2</td>
  <td>1</td>
  </tr>
  <tr>
  <td>3/3</td>
  <td>1</td>
  </tr>
  <tr>
  <td>4/4</td>
  <td>2</td>
  </tr>
  <tr>
  <td>5/5</td>
  <td>2</td>
  </tr>
  <tr>
  <td>6/6</td>
  <td>3</td>
  </tr>
  <tr>
  <td>7/7</td>
  <td>3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Container ID is a foreign key to another table and the containers are effectively named groups that elements can be part of.</p>
  <p>I'm looking to write a query that gets the earliest date for each <code>Container ID</code> like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Earliest Date</th>
  <th>Container ID</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1/1</td>
  <td>1</td>
  </tr>
  <tr>
  <td>4/4</td>
  <td>2</td>
  </tr>
  <tr>
  <td>6/6</td>
  <td>3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Is there some way I can join on Container ID to make this happen or am I on the wrong path with joins?</p>