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

what is the 2008 when 2007 is A, 2011 is A and tournament is san jose?
SELECT "2008" FROM table_9978 WHERE "2007" = 'a' AND "2011" = 'a' AND "Tournament" = 'san jose'
SELECT "2008" FROM "table_9978" WHERE "2007" = 'a' AND "2011" = 'a' AND "Tournament" = 'san jose'