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 o lead tpt para baixo de kevin tomanka e alto 1 de alan moffett
 ###Tabelas: CREATE TABLE endangered_wildlife_series (endangered_wildlife_series_id AUTO_INCREMENT PRIMARY KEY, Year INT, Theme VARCHAR, Face Values VARCHAR, Artist VARCHAR, Issue Price VARCHAR, Mintage INT, Finish VARCHAR) CREATE TABLE conference_player_of_the_month_selections (conference_player_of_the_month_selections_id AUTO_INCREMENT PRIMARY KEY, Selection INT, Month VARCHAR, Season VARCHAR, Team record VARCHAR, Points per game VARCHAR, Field goal percentage VARCHAR, Rebounds per game VARCHAR, Blocks per game VARCHAR) CREATE TABLE handicap_results_top_10 (handicap_results_top_10_id AUTO_INCREMENT PRIMARY KEY, Position INT, Sail number VARCHAR, Yacht VARCHAR, State/country VARCHAR, Yacht type VARCHAR, LOA (Metres) VARCHAR, Skipper VARCHAR, Corrected time d:hh:mm:ss VARCHAR) CREATE TABLE history_of_ggb_members (history_of_ggb_members_id AUTO_INCREMENT PRIMARY KEY, Alto 1 VARCHAR, Alto 2 VARCHAR, Tenor VARCHAR, Lead Tpt VARCHAR, Tpt 2 VARCHAR, Tpt 3 VARCHAR, Mello VARCHAR, Lead Bone VARCHAR, Bass Bone VARCHAR, Bass VARCHAR, Drums VARCHAR) CREATE TABLE rodney_local_board (rodney_local_board_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Years VARCHAR, Area VARCHAR, Authority VARCHAR, Decile INT, Roll INT)  
SELECT Lead Tpt FROM history_of_ggb_members WHERE Bass = kevin tomanka AND Alto 1 = alan moffett