Table: granollers_tournaments
Columns: tournament
2006
2007
2008
2009
2010
2011
2012

Question: What is the 2011 value that has ATP Masters Series in 2007?
SQL: SELECT "2011" FROM granollers_tournaments WHERE "2007" = 'atp masters series'

Question: What is the 2011 value that has a 2r in 2008 and a 4r in 2012?
SQL: SELECT "2011" FROM granollers_tournaments WHERE "2008" = '2r' AND "2012" = '4r'

Question: What is the 2012 value with an A value in 2007 and A value in 2010 in the Canada Masters?
SQL: SELECT "2012" FROM granollers_tournaments WHERE "2007" = 'a' AND "2010" = 'a' AND "tournament" = 'canada masters'

Question: What is the 2012 value with 1r in 2011, 2007 of A, 2010 of 1r, and 2009 of A?
SQL: SELECT "2012" FROM granollers_tournaments WHERE "2011" = '1r' AND "2007" = 'a' AND "2010" = '1r' AND "2009" = 'a'

Question: What is the 2007 value with NMS in 2011?
SQL: SELECT "2007" FROM granollers_tournaments WHERE "2011" = 'nms'