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 que semana houve mais de 23.875 pessoas presentes no Estádio Memorial com o Detroit Lions como oponente?
 ###Tabelas: CREATE TABLE schedule (schedule_id AUTO_INCREMENT PRIMARY KEY, Week INT, Date VARCHAR, Opponent VARCHAR, Result VARCHAR, Record VARCHAR, Game Site VARCHAR, Attendance INT) CREATE TABLE other_stakes_with_congregations_in_arkansas (other_stakes_with_congregations_in_arkansas_id AUTO_INCREMENT PRIMARY KEY, Stake VARCHAR, Organized VARCHAR, Number of Wards/ Branches in Arkansas INT, Stake President VARCHAR, Occupation VARCHAR) CREATE TABLE deficit_spending (deficit_spending_id AUTO_INCREMENT PRIMARY KEY, End of Fiscal Year INT, Gross Debt in $Billions undeflated Treas. INT, as % of GDP Low-High VARCHAR, Debt Held By Public ($Billions) INT, as % of GDP (Treas/MW, OMB or OMB/MW) INT, GDP $Billions OMB/BEA est.=MW.com VARCHAR) CREATE TABLE average_chart (average_chart_id AUTO_INCREMENT PRIMARY KEY, Rank by average INT, Competition finish INT, Couple VARCHAR, Total INT, Number of dances INT, Average VARCHAR) CREATE TABLE list_of_sovereign_nations_with_fewer_than_500000_people (list_of_sovereign_nations_with_fewer_than_500000_people_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Country/territory/entity VARCHAR, Population INT, % of world population VARCHAR, Region VARCHAR)  
SELECT AVG Week FROM schedule WHERE Attendance > 23,875 AND Game Site = memorial stadium AND Opponent = detroit lions