title: The oldest person in a birthday table. SQL subquery
body: <p>I am trying to find the oldest person in my Members' birthday table from Vermont and New York. My Members resembles the following:</p>
  
  <pre><code>Members
  -------
  MemberID, Firstname, Lastname, Birthday, Region
  </code></pre>
  
  <p>I formulated the following subquery:</p>
  
  <pre><code>SELECT lastname 
  FROM members 
  WHERE region = 'VT' 
    AND year(birthday) &gt; (SELECT year(birthday) 
                          FROM members 
                          WHERE region = 'NY')
  </code></pre>
  
  <p>SQL query system tells me that it returns more than one row. What am I missing in it and is it logically correct? Again, am I asking how I can find every member in Vermont who is older than all the members from NY.</p>