CREATE TABLE table_67456 ("State" CLOB, "Date" CLOB, "Yes vote" CLOB, "No vote" CLOB, "Vote outcome" CLOB)

How many positive votes for Tennessee in 2006?
SELECT "Yes vote" FROM table_67456 WHERE "Date" = '2006' AND "State" = 'tennessee'
SELECT "Yes vote" FROM "table_67456" WHERE "Date" = '2006' AND "State" = 'tennessee'