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 McCain recebeu em Scott?
 ###Tabelas: CREATE TABLE winners_of_the_barbaro_stakes_since_1993 (winners_of_the_barbaro_stakes_since_1993_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Winner VARCHAR, Jockey VARCHAR, Trainer VARCHAR, Owner VARCHAR, Distance VARCHAR, Time VARCHAR, Purse VARCHAR) CREATE TABLE by_county (by_county_id AUTO_INCREMENT PRIMARY KEY, County VARCHAR, Obama% VARCHAR, Obama# INT, McCain% VARCHAR, McCain# INT) CREATE TABLE best_figures_in_a_match (best_figures_in_a_match_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, Bowling VARCHAR, Player VARCHAR, Opponent VARCHAR, Venue VARCHAR, Season VARCHAR) CREATE TABLE american_weekly_ratings (american_weekly_ratings_id AUTO_INCREMENT PRIMARY KEY, Episode VARCHAR, Air Date VARCHAR, Timeslot (EST) VARCHAR, Rating INT, Share VARCHAR, 18–49 Rating VARCHAR, Viewers (millions) INT, Rank VARCHAR) CREATE TABLE number_of_children_involved_in_ilo_categories_of_work_by_age_and_gender (number_of_children_involved_in_ilo_categories_of_work_by_age_and_gender_id AUTO_INCREMENT PRIMARY KEY, All Children ('000s) INT, Economically Active Children ('000s) INT, Economically Active Children (%) INT, Child Labour ('000s) INT, Child Labour (%) INT, Children In Hazardous Work ('000s) INT, Children In Hazardous Work (%) INT)  
SELECT MIN McCain# FROM by_county WHERE County = Scott