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: Nomeie todos os torneios que ocorreram em Rhode Island.
 ###Tabelas: CREATE TABLE tournament_results (tournament_results_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Tournament VARCHAR, Location VARCHAR, Purse( $ ) INT, Winner VARCHAR, Score VARCHAR, 1st Prize( $ ) INT) CREATE TABLE mutya_ng_pilipinas_asia_pacific_titleholders_and_runners-up (mutya_ng_pilipinas_asia_pacific_titleholders_and_runners-up_id AUTO_INCREMENT PRIMARY KEY, Year INT, Mutya ng Pilipinas Asia Pacific VARCHAR, 1st runner-up VARCHAR, 2nd runner-up VARCHAR, 3rd runner-up VARCHAR, 4th runner-up VARCHAR) CREATE TABLE top_100_in_the_united_states (top_100_in_the_united_states_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Name VARCHAR, Location VARCHAR, State VARCHAR, Designer, Year VARCHAR) CREATE TABLE results_pool_d (results_pool_d_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Score VARCHAR, Set 1 VARCHAR, Set 2 VARCHAR, Set 3 VARCHAR, Set 4 VARCHAR, Set 5 VARCHAR, Total VARCHAR) CREATE TABLE doubles_finals_6–2 (doubles_finals_6–2_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score VARCHAR)  
SELECT Tournament FROM tournament_results WHERE Location = Rhode Island