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 faculdade o jogador da South Medford High School está indo?
 ###Tabelas: CREATE TABLE michigan_single-game_reception_yardage (michigan_single-game_reception_yardage_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Rec. INT, Yards INT, Average INT, s Touchdown INT, Year INT, Opponent VARCHAR) CREATE TABLE for_actors_in_woody_allen_films (for_actors_in_woody_allen_films_id AUTO_INCREMENT PRIMARY KEY, Year INT, Film VARCHAR, Result VARCHAR, Category VARCHAR, Actor VARCHAR) CREATE TABLE doubles:_11_1–10 (doubles:_11_1–10_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE lpga_tour_career_summary (lpga_tour_career_summary_id AUTO_INCREMENT PRIMARY KEY, Year INT, Tournaments played INT, Cuts made* INT, Wins INT, Top 10s INT, Best finish VARCHAR, Earnings ($) INT, Money list rank VARCHAR, Scoring average INT, Scoring rank VARCHAR) CREATE TABLE 2007_boys'_team (2007_boys'_team_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Height VARCHAR, School VARCHAR, Hometown VARCHAR, College VARCHAR)  
SELECT College FROM 2007_boys'_team WHERE School = south medford high school