title: Mysql return matching users in subqueries
body: <p>I'm looking for a way to write one query to compare the results of multiple mysql subqueries, and return users that are in each query.</p>
  
  <p>I have a that contains fantasy football stats for players.  To simplify, in this case there are 3 columns I'm using: player, points, year.</p>
  
  <p>I'm looking to run a query that returns a list of players who finished in the top 50 (based on points) in both 2010 and 2011.</p>
  
  <p>I've done lots of searching around on playing with subqueries, doing joins on one table, etc but am still coming up at a loss on how to approach this.</p>