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 semana 6 de outubro tem uma semana 14 de novembro do Texas (11-1)?
 ###Tabelas: CREATE TABLE detailed_overview (detailed_overview_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Place of Birth VARCHAR, Date of Birth VARCHAR, Club Apps. VARCHAR, Club Goals VARCHAR, Int. Caps VARCHAR, Int. Goals VARCHAR, Previous Club VARCHAR, Date Joined VARCHAR, End 1 INT) CREATE TABLE coaches'_poll (coaches'_poll_id AUTO_INCREMENT PRIMARY KEY, Week 1 Sept 2 VARCHAR, Week 2 Sept 7 VARCHAR, Week 3 Sept 14 VARCHAR, Week 5 Sept 28 VARCHAR, Week 6 Oct 5 VARCHAR, Week 7 Oct 12 VARCHAR, Week 10 Nov 2 VARCHAR, Week 13 Nov 23 VARCHAR, Week 14 Nov 30 VARCHAR, Week 15 Dec 7 VARCHAR, Week 16 (Final) Jan 9 VARCHAR) CREATE TABLE los_angeles_kings_4_edmonton_oilers_3 (los_angeles_kings_4_edmonton_oilers_3_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Visitor VARCHAR, Score VARCHAR, Home VARCHAR, Record VARCHAR) CREATE TABLE television (television_id AUTO_INCREMENT PRIMARY KEY, Dish VARCHAR, Callsign VARCHAR, Network VARCHAR, Resolution VARCHAR, City of License VARCHAR, Official Website VARCHAR) CREATE TABLE performance_by_team (performance_by_team_id AUTO_INCREMENT PRIMARY KEY, Champions VARCHAR, Runners-up VARCHAR, Third-place VARCHAR, Fourth-place VARCHAR, Semi-finalists VARCHAR)  
SELECT Week 6 Oct 5 FROM coaches'_poll WHERE Week 14 Nov 30 = texas (11-1)