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: Em quantos dos colomel do Arkansas o condado era o papa.
 ###Tabelas: CREATE TABLE past_production (past_production_id AUTO_INCREMENT PRIMARY KEY, Headphone Model VARCHAR, Headphone Class VARCHAR, Sensitivity (dB) VARCHAR, Impedance (Ohms) INT, Driver-matched dB VARCHAR, Construction VARCHAR, Earpads VARCHAR, Termination VARCHAR, Succeeded by VARCHAR) CREATE TABLE performances_results (performances_results_id AUTO_INCREMENT PRIMARY KEY, Week VARCHAR, Theme VARCHAR, Song choice VARCHAR, Original artist VARCHAR, Result VARCHAR) CREATE TABLE nutritional_content (nutritional_content_id AUTO_INCREMENT PRIMARY KEY, Total fat VARCHAR, Saturated fat VARCHAR, Monounsaturated fat VARCHAR, Polyunsaturated fat VARCHAR, Smoke point VARCHAR) CREATE TABLE season_1:_2003–2004 (season_1:_2003–2004_id AUTO_INCREMENT PRIMARY KEY, Series # INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Original air date VARCHAR, Production code INT) CREATE TABLE arkansas_militia_act_of_1843 (arkansas_militia_act_of_1843_id AUTO_INCREMENT PRIMARY KEY, Division VARCHAR, Brigade VARCHAR, Regiment VARCHAR, Colonel VARCHAR, County VARCHAR)  
SELECT COUNT Colonel FROM arkansas_militia_act_of_1843 WHERE County = Pope