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: question: Nomeie o número mais alto de abama para mccain sendo 29266
 ###Tabelas: CREATE TABLE nominations__&__awards (nominations__&__awards_id AUTO_INCREMENT PRIMARY KEY, Year INT, Artist VARCHAR, Album / Song VARCHAR, Award VARCHAR, Result / Category VARCHAR) CREATE TABLE doubles:_20_8–12 (doubles:_20_8–12_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date INT, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE by_county (by_county_id AUTO_INCREMENT PRIMARY KEY, County VARCHAR, Obama% VARCHAR, Obama# INT, McCain% VARCHAR, McCain# INT, Others% VARCHAR, Others# INT, Total INT) CREATE TABLE head-to-head_records_against_other_countries (head-to-head_records_against_other_countries_id AUTO_INCREMENT PRIMARY KEY, Games INT, Wins INT, Draws INT, Losses INT, Goals For INT, Goals Against INT, Goal Differential VARCHAR) CREATE TABLE grand_prix_career_statistics (grand_prix_career_statistics_id AUTO_INCREMENT PRIMARY KEY, Year INT, Class VARCHAR, Team VARCHAR, Machine VARCHAR, Points INT, Wins INT)  
SELECT MAX Obama# FROM by_county WHERE McCain# = 29266