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 é o clube quando o presidente é Roger Lambrecht?
 ###Tabelas: CREATE TABLE marriage_statistics (marriage_statistics_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Marriages between men INT, Marriages between women INT, Same-sex marriages INT, Total marriages INT, % same-sex marriages VARCHAR) CREATE TABLE republic_of_korea_1948-presents (republic_of_korea_1948-presents_id AUTO_INCREMENT PRIMARY KEY, President VARCHAR, Vice INT, Romanized (Hangul) VARCHAR, Took office VARCHAR, Left office VARCHAR, Political party VARCHAR) CREATE TABLE nfhs_data (nfhs_data_id AUTO_INCREMENT PRIMARY KEY, States VARCHAR, Males (%) VARCHAR, Males rank INT, Females (%) VARCHAR, Females rank INT) CREATE TABLE personnel_and_sponsoring (personnel_and_sponsoring_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Chairman VARCHAR, Current manager VARCHAR, Team captain VARCHAR, Kitmaker VARCHAR, Shirt sponsor VARCHAR) CREATE TABLE mixed_doubles:_8_4–4 (mixed_doubles:_8_4–4_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Year INT, Championship VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score in the final VARCHAR)  
SELECT Club FROM personnel_and_sponsoring WHERE Chairman = Roger Lambrecht