title: SQL Return value based on lowest value in another column
body: <p>I've tried to search for a solution to this but have been unable to find one.  I guess it's basic SQL, but I can't seem to figure it out.</p>
  
  <p>I have a table called people, this table has several columns:</p>
  
  <pre><code>ID  Firstname Lastname   Birthdate
  1   John      Stevenson  1860-07-30
  2   Eric      Johnson    1918-08-25
  3   Adam      Efron      1914-02-02
  4   Michael   Gray       1870-07-18
  </code></pre>
  
  <p>Now I want to make a query that looks at the Birthdate column, finds the lowest value and returns the firstname of the person that has the lowest birthdate (is oldest).
  Can someone guide me in the right direction?
  THanks in advance!</p>