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 nome do shortstop quando o Catcher era johnny roseboro, e um Third Baseman de jim lefebvre, e um Second Baseman de nate oliver?
 ###Tabelas: CREATE TABLE opening_day_starting_lineups (opening_day_starting_lineups_id AUTO_INCREMENT PRIMARY KEY, Year INT, Catcher VARCHAR, First Baseman VARCHAR, Second Baseman VARCHAR, Shortstop VARCHAR, Third Baseman VARCHAR, Rightfielder VARCHAR, Centerfielder VARCHAR, Leftfielder VARCHAR, Starting Pitcher VARCHAR) CREATE TABLE 1992_draft_picks (1992_draft_picks_id AUTO_INCREMENT PRIMARY KEY, Round INT, Overall INT, Player VARCHAR, Nationality VARCHAR, Club team VARCHAR) CREATE TABLE fares (fares_id AUTO_INCREMENT PRIMARY KEY, Type of Fare VARCHAR, Cash Fare VARCHAR, Day Pass VARCHAR, 31-Day Pass VARCHAR, Monthly Pass VARCHAR) CREATE TABLE list_of_dmfas_programme_managers_and_chiefs (list_of_dmfas_programme_managers_and_chiefs_id AUTO_INCREMENT PRIMARY KEY, Number INT, Name VARCHAR, Dates in office VARCHAR, Country of origin VARCHAR, Remarks VARCHAR) CREATE TABLE general_election_results (general_election_results_id AUTO_INCREMENT PRIMARY KEY, Election INT, Leader VARCHAR, # of candidates INT, # of Constituency votes INT, % of Constituency vote VARCHAR)  
SELECT Shortstop FROM opening_day_starting_lineups WHERE Catcher = johnny roseboro AND Third Baseman = jim lefebvre AND Second Baseman = nate oliver