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 oponente na Richmond Academy?
 ###Tabelas: CREATE TABLE 2009_season_schedule (2009_season_schedule_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Opponent VARCHAR, Home / Away VARCHAR, Score VARCHAR, High points VARCHAR, High rebounds VARCHAR, High assists VARCHAR, Location/Attendance VARCHAR, Record VARCHAR) CREATE TABLE doubles_titles (doubles_titles_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partnering VARCHAR, Opponents in the final VARCHAR, Score VARCHAR) CREATE TABLE ships_in_class (ships_in_class_id AUTO_INCREMENT PRIMARY KEY, Ship VARCHAR, Hull Number VARCHAR, Laid down VARCHAR, Launched VARCHAR, Commissioned VARCHAR) CREATE TABLE current_composition (current_composition_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Rank VARCHAR, Years until mandatory retirement VARCHAR, Appointed by VARCHAR, Year appointed INT) CREATE TABLE goals_for_senior_national_team (goals_for_senior_national_team_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Venue VARCHAR, Score VARCHAR, Result VARCHAR, Competition VARCHAR)  
SELECT Opponent FROM 2009_season_schedule WHERE Location/Attendance = richmond academy