Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Quantos votos positivos para Tennessee em 2006?
 ###Tabelas: CREATE TABLE league_statistics (league_statistics_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Overall Spectators INT, Per game INT, Best supported Club VARCHAR, Spectators /game INT, Top goal scorer VARCHAR, Goals INT) CREATE TABLE regular_and_capital_gains_tax_rates_for_2009 (regular_and_capital_gains_tax_rates_for_2009_id AUTO_INCREMENT PRIMARY KEY, Marginal Ordinary Income Tax Rate VARCHAR, Single VARCHAR, Married Filing Jointly or Qualified Widow(er) VARCHAR, Married Filing Separately VARCHAR, Head of Household VARCHAR) CREATE TABLE list_of_special_representatives (list_of_special_representatives_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Born-Died VARCHAR, Took Office VARCHAR, Left Office VARCHAR, Country VARCHAR) CREATE TABLE itf__doubles_27__15-12 (itf__doubles_27__15-12_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score VARCHAR) CREATE TABLE states_that_have_voted_on_amendments (states_that_have_voted_on_amendments_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, Date VARCHAR, Yes vote VARCHAR, No vote VARCHAR, Vote outcome VARCHAR)  
SELECT Yes vote FROM states_that_have_voted_on_amendments WHERE Date = 2006 AND State = tennessee