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 rascunhos apresentaram Fred Hoaglin?
 ###Tabelas: CREATE TABLE main_transmitters (main_transmitters_id AUTO_INCREMENT PRIMARY KEY, Region served VARCHAR, City VARCHAR, Channels ( Analog / Digital ) VARCHAR, First air date VARCHAR, ERP (Analog/ Digital) VARCHAR, HAAT (Analog/ Digital) 1 VARCHAR, Transmitter Location VARCHAR) CREATE TABLE eastern_conference_quarter-finals:_vs._1_new_jersey_devils (eastern_conference_quarter-finals:_vs._1_new_jersey_devils_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Visitor VARCHAR, Score VARCHAR, Home VARCHAR, Record VARCHAR) CREATE TABLE player_selection (player_selection_id AUTO_INCREMENT PRIMARY KEY, Year INT, Pick VARCHAR, Player VARCHAR, Position VARCHAR, College VARCHAR) CREATE TABLE table_presidential_elections (table_presidential_elections_id AUTO_INCREMENT PRIMARY KEY, Election VARCHAR, Candidate VARCHAR, Number of votes VARCHAR, Share of votes VARCHAR, Outcome of election VARCHAR) CREATE TABLE nfl_draft (nfl_draft_id AUTO_INCREMENT PRIMARY KEY, Round INT, Overall INT, Player VARCHAR, Position VARCHAR, School/Club Team VARCHAR)  
SELECT COUNT Overall FROM nfl_draft WHERE Player = fred hoaglin