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

Question: what is the 2008 when 2007 is A, 2011 is A and tournament is san jose?
SQL: SELECT "2008" FROM giraldo_tournaments WHERE "2007" = 'a' AND "2011" = 'a' AND "tournament" = 'san jose'

Question: what is 2010 when 2011 is 2r and 2008 is 2r?
SQL: SELECT "2010" FROM giraldo_tournaments WHERE "2011" = '2r' AND "2008" = '2r'

Question: what is 2007 when 2011 is not held and 2012 is not held?
SQL: SELECT "2007" FROM giraldo_tournaments WHERE "2011" = 'not held' AND "2012" = 'not held'

Question: what is the tournament when 2011 is a, 2009 is lq and 2012 is 1r?
SQL: SELECT "tournament" FROM giraldo_tournaments WHERE "2011" = 'a' AND "2009" = 'lq' AND "2012" = '1r'

Question: what is 2008 when 2007 is a, 2011 is a, 2010 is a and tournament is china?
SQL: SELECT "2008" FROM giraldo_tournaments WHERE "2007" = 'a' AND "2011" = 'a' AND "2010" = 'a' AND "tournament" = 'china'