Table: james_ward_tennis_stats
Columns: tournament
2007
2008
2009
2010
2011
2012

Question: What is the 2011 entry for the row with a 2007 entry of 558?
SQL: SELECT "2011" FROM james_ward_tennis_stats WHERE "2007" = '558'

Question: What is the 2010 entry for the row that has a 2009 entry of 270?
SQL: SELECT "2010" FROM james_ward_tennis_stats WHERE "2009" = '270'

Question: What is the 2009 entry for the row that has a 2007 entry of A and a tournament entry of US Open?
SQL: SELECT "2009" FROM james_ward_tennis_stats WHERE "2007" = 'a' AND "tournament" = 'us open'

Question: What is the 2008 entry for the row that as a 2011 entry of 1R?
SQL: SELECT "2008" FROM james_ward_tennis_stats WHERE "2011" = '1r'