Table: igor_andreev_tournaments
Columns: tournament
2004
2005
2006
2007
2008
2009
2010
2011

Question: What is 2008, when 2006 is "1R"?
SQL: SELECT "2008" FROM igor_andreev_tournaments WHERE "2006" = '1r'

Question: What is Tournament, when 2006 is "A", and when 2009 is "A"?
SQL: SELECT "tournament" FROM igor_andreev_tournaments WHERE "2006" = 'a' AND "2009" = 'a'

Question: What is 2005, when 2006 is "1R"?
SQL: SELECT "2005" FROM igor_andreev_tournaments WHERE "2006" = '1r'

Question: What is 2011, when 2008 is "2R"?
SQL: SELECT "2011" FROM igor_andreev_tournaments WHERE "2008" = '2r'

Question: What is 2004, when 2005 is "2R", and when 2006 is "1R"
SQL: SELECT "2004" FROM igor_andreev_tournaments WHERE "2005" = '2r' AND "2006" = '1r'

Question: What is 2004, when 2009 is "A"?
SQL: SELECT "2004" FROM igor_andreev_tournaments WHERE "2009" = 'a'