title: Select "lowest value" from table for multiple "ids"
body: <p>I read up last night on using the sql MIN() and I understand how it works now. However, I was wondering, how do I run </p>
  
  <pre><code>SELECT MIN(card_price)
  FROM card_lookup_values 
  </code></pre>
  
  <p>and display the lowest "price" for each individual card. A lot of the cards have 5-9 prices in the card_price column. I guess I was looking for:</p>
  
  <pre><code> card_id   card_price
      0001      2
      0002      99
      0003      22.3
  </code></pre>