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 é a média de comparecimento na semana anterior ao dia 6 de outubro de 2001?
 ###Tabelas: CREATE TABLE heats (heats_id AUTO_INCREMENT PRIMARY KEY, Heat Rank INT, Lane INT, Swimmer VARCHAR, Country VARCHAR, Time INT, Overall Rank VARCHAR) CREATE TABLE cantonal_school_systems (cantonal_school_systems_id AUTO_INCREMENT PRIMARY KEY, Canton VARCHAR, Years of Kindergarten INT, Years of Kindergarten provided VARCHAR, Years of Kindergarten legally required VARCHAR, Length of Primary School INT, Length of mandatory Secondary School INT, Separate Secondary Schools? VARCHAR, Cooperative Secondary Schools? VARCHAR, Integrated Secondary Schools? VARCHAR) CREATE TABLE list_of_csl_teams (list_of_csl_teams_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, City VARCHAR, Total Seasons INT, Seasons VARCHAR, Highest League VARCHAR) CREATE TABLE list_of_oldest_sitting_mps_since_1945 (list_of_oldest_sitting_mps_since_1945_id AUTO_INCREMENT PRIMARY KEY, Born VARCHAR, Became oldest MP VARCHAR, Left House VARCHAR, Age on leaving VARCHAR, Died VARCHAR, Political Party VARCHAR) CREATE TABLE schedule (schedule_id AUTO_INCREMENT PRIMARY KEY, Week INT, Date VARCHAR, Opponent VARCHAR, Result VARCHAR, TV Time VARCHAR, Attendance INT)  
SELECT AVG Attendance FROM schedule WHERE Week < 6 AND Date = october 14, 2001