CREATE TABLE table_38647 ("Tournament" CLOB, "2006" CLOB, "2007" CLOB, "2008" CLOB, "2009" CLOB, "2010" CLOB, "2011" CLOB, "2012" CLOB)

Which 2009 has a 2008 of A, and a 2010 of 4r?
SELECT "2009" FROM table_38647 WHERE "2008" = 'a' AND "2010" = '4r'
SELECT "2009" FROM "table_38647" WHERE "2008" = 'a' AND "2010" = '4r'