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: Para a qual equipe Anthony Redmond pilota?
 ###Tabelas: CREATE TABLE race_6b;_ultra-lightweight_manx_grand_prix (race_6b;_ultra-lightweight_manx_grand_prix_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Rider VARCHAR, Team VARCHAR, Speed VARCHAR, Time VARCHAR) CREATE TABLE consolation_night_series_lake_oval_winners_1956–1971 (consolation_night_series_lake_oval_winners_1956–1971_id AUTO_INCREMENT PRIMARY KEY, Year INT, Winners VARCHAR, Grand Finalist VARCHAR, Scores VARCHAR, Venue VARCHAR, Crowd INT, Margin INT, Season Result VARCHAR) CREATE TABLE important_originating_express_trains (important_originating_express_trains_id AUTO_INCREMENT PRIMARY KEY, Train No. VARCHAR, Train Name VARCHAR, Destination VARCHAR, Category VARCHAR, Frequency VARCHAR) CREATE TABLE us_states_by_asian_americans_population (us_states_by_asian_americans_population_id AUTO_INCREMENT PRIMARY KEY, State/Territory VARCHAR, Asian American Population (2010 Census) INT, Chinese INT, Filipino INT, Indian INT, Japanese INT, Korean INT, Vietnamese INT, Other Asian INT) CREATE TABLE _ (__id AUTO_INCREMENT PRIMARY KEY, City / Municipality VARCHAR, Date of Creation VARCHAR, Area (km 2 ) VARCHAR, Population (2010) INT, Income Classification ( DOF ) VARCHAR)  
SELECT Team FROM race_6b;_ultra-lightweight_manx_grand_prix WHERE Rider = anthony redmond