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: Qual é o resultado da semana 1 do Colorado State?
 ###Tabelas: CREATE TABLE ap_poll (ap_poll_id AUTO_INCREMENT PRIMARY KEY, Preseason VARCHAR, Week 1 Sept 7 VARCHAR, Week 2 Sept 14 VARCHAR, Week 3 Sept 21 VARCHAR, Week 4 Sept 28 VARCHAR, Week 5 Oct 5 VARCHAR, Week 6 Oct 12 VARCHAR, Week 7 Oct 19 VARCHAR, Week 8 Oct 26 VARCHAR, Week 9 Nov 2 VARCHAR, Week 10 Nov 9 VARCHAR, Week 11 Nov 16 VARCHAR, Week 12 Nov 23 VARCHAR, Week 13 Nov 30 VARCHAR, Week 14 Dec 7 VARCHAR, Week 15 (Final) Jan 5 VARCHAR) CREATE TABLE results_by_ward (results_by_ward_id AUTO_INCREMENT PRIMARY KEY, Ward VARCHAR, Bello VARCHAR, Ben-Tahir VARCHAR, Doucet VARCHAR, Furtenbacher VARCHAR, Gauthier VARCHAR, Haydon VARCHAR, Larter VARCHAR, Lawrance VARCHAR, Libweshya VARCHAR, Liscumb VARCHAR) CREATE TABLE primary_education (primary_education_id AUTO_INCREMENT PRIMARY KEY, Measure VARCHAR, Bombali INT, Bonthe INT, Kailahun INT, Kambia VARCHAR, Kenema INT, Koinadugu INT, Kono INT, Moyamba VARCHAR, Port Loko VARCHAR, Pujehun INT, Tonkolili INT) CREATE TABLE jersey_progress (jersey_progress_id AUTO_INCREMENT PRIMARY KEY, Stage VARCHAR, Winner VARCHAR, General classification VARCHAR, Points Classification VARCHAR, Team Classification VARCHAR) CREATE TABLE fm (fm_id AUTO_INCREMENT PRIMARY KEY, Station VARCHAR, Frequency INT, Network Affiliation VARCHAR, Format VARCHAR, City of License VARCHAR, Status VARCHAR)  
SELECT Week 1 Sept 7 FROM ap_poll WHERE Preseason = colorado state