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: Quem eram os semifinalistas do torneio de Hamburgo?
 ###Tabelas: CREATE TABLE compounds_from_marine_sources_in_clinical_level (compounds_from_marine_sources_in_clinical_level_id AUTO_INCREMENT PRIMARY KEY, Clinical Status VARCHAR, Compound Name VARCHAR, Trademark VARCHAR, Marine Organism α VARCHAR, Chemical Class VARCHAR, Molecular Target VARCHAR, Clinical Trials β VARCHAR, Disease Area VARCHAR) CREATE TABLE composition_of_the_17th_seanad (composition_of_the_17th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE singles (singles_id AUTO_INCREMENT PRIMARY KEY, Tournament VARCHAR, Surface VARCHAR, Week VARCHAR, Winner VARCHAR, Finalist VARCHAR, Semifinalists VARCHAR) CREATE TABLE round_five (round_five_id AUTO_INCREMENT PRIMARY KEY, Pick # INT, CFL Team VARCHAR, Player VARCHAR, Position VARCHAR, College VARCHAR) CREATE TABLE programs_returning_during_2000 (programs_returning_during_2000_id AUTO_INCREMENT PRIMARY KEY, Show VARCHAR, Last Aired INT, Previous Network VARCHAR, Retitled as/Same VARCHAR, New/Returning/Same Network VARCHAR, Returning VARCHAR)  
SELECT Semifinalists FROM singles WHERE Tournament = hamburg