Table: liga_dekmeijere_tournaments
Columns: tournament
2006
2009
2012
2013

Question: What shows for 2006, when 2013 is 2–4?
SQL: SELECT "2006" FROM liga_dekmeijere_tournaments WHERE "2013" = '2–4'

Question: What shows for 2013 when the 2012 is 2r, and a 2009 is 2r?
SQL: SELECT "2013" FROM liga_dekmeijere_tournaments WHERE "2012" = '2r' AND "2009" = '2r'

Question: What is the 2006 when the 2013 is 1r, and the 2012 is 1r?
SQL: SELECT "2006" FROM liga_dekmeijere_tournaments WHERE "2013" = '1r' AND "2012" = '1r'

Question: What is the 2006 when the 2013 is 2r, and a Tournament was the us open?
SQL: SELECT "2006" FROM liga_dekmeijere_tournaments WHERE "2013" = '2r' AND "tournament" = 'us open'

Question: What is the Tournament when the 2013 is 2r, and a 2006 is 1r?
SQL: SELECT "tournament" FROM liga_dekmeijere_tournaments WHERE "2013" = '2r' AND "2006" = '1r'

Question: What is the Tournament when the 2013 is 1r?
SQL: SELECT "tournament" FROM liga_dekmeijere_tournaments WHERE "2013" = '1r'