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 esporte tem uma liga da liga continental de basquete e um local da escola média de avalon?
 ###Tabelas: CREATE TABLE fighters_with_the_most_awards (fighters_with_the_most_awards_id AUTO_INCREMENT PRIMARY KEY, Fighter VARCHAR, Fights of the Night INT, Knockouts of the Night INT, Submissions of the Night INT, Awards Total INT, Status VARCHAR) CREATE TABLE minor_sports_teams (minor_sports_teams_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Sport VARCHAR, League VARCHAR, Venue VARCHAR, Championships (Years) VARCHAR) CREATE TABLE allegations_of_children_born_to_alleged_polygamous_wives (allegations_of_children_born_to_alleged_polygamous_wives_id AUTO_INCREMENT PRIMARY KEY, Child VARCHAR, Date of birth VARCHAR, Mother VARCHAR, Father VARCHAR, DNA testing status VARCHAR) CREATE TABLE west_german_champions_1973–1997 (west_german_champions_1973–1997_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Champions VARCHAR, Score VARCHAR, Runners-up VARCHAR, Venue VARCHAR) CREATE TABLE season_5_1992 (season_5_1992_id AUTO_INCREMENT PRIMARY KEY, Number in series INT, Number in season INT, Title VARCHAR, Directed by VARCHAR, Original air date VARCHAR, Production code VARCHAR)  
SELECT Sport FROM minor_sports_teams WHERE League = continental basketball league AND Venue = avalon middle school