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 equipe os Flames jogaram contra quando 526 pessoas compareceram ao jogo?
 ###Tabelas: CREATE TABLE october (october_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Opponent VARCHAR, Venue VARCHAR, Result VARCHAR, Attendance INT, Competition VARCHAR, Man of the Match VARCHAR) CREATE TABLE rjfm_stations (rjfm_stations_id AUTO_INCREMENT PRIMARY KEY, Branding VARCHAR, Callsign VARCHAR, Frequency VARCHAR, Power (kW) VARCHAR, Station Type VARCHAR, Location VARCHAR) CREATE TABLE general_election (general_election_id AUTO_INCREMENT PRIMARY KEY, Poll source VARCHAR, Date(s) administered VARCHAR, Sample size VARCHAR, Margin of error VARCHAR, Jerry Brown (D) VARCHAR, Meg Whitman (R) VARCHAR) CREATE TABLE shipyards_in_the_program (shipyards_in_the_program_id AUTO_INCREMENT PRIMARY KEY, Yard Name VARCHAR, Location (City, State) VARCHAR, 1st Ship Delivery Date VARCHAR, Ship Types Delivered VARCHAR, Total Number of Ways VARCHAR) CREATE TABLE ap_poll (ap_poll_id AUTO_INCREMENT PRIMARY KEY, Week 2 Sept 7 VARCHAR, Week 3 Sept 14 VARCHAR, Week 4 Sept 21 VARCHAR, Week 5 Sept 28 VARCHAR, Week 6 Oct 5 VARCHAR, Week 7 Oct 12 VARCHAR, Week 10 Nov 2 VARCHAR, Week 12 Nov 16 VARCHAR, Week 14 Nov 30 VARCHAR, Week 15 Dec 7 VARCHAR, Week 16 (Final) Jan 9 VARCHAR)  
SELECT Opponent FROM october WHERE Attendance = 526