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 último para softball antes de 2000.
 ###Tabelas: CREATE TABLE snp_targets (snp_targets_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Constituency VARCHAR, Winning party 2003 VARCHAR, Swing to gain INT, SNP's place 2003 VARCHAR, Result VARCHAR) CREATE TABLE analytical_table (analytical_table_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, Votes INT, Votes since 1856 INT, Democratic votes INT, D votes since 1856 INT, % of D votes VARCHAR, D % since 1856 VARCHAR, Republican votes INT, % of R votes VARCHAR, R % since 1856 VARCHAR, Other votes INT, O votes since 1856 INT, % of O votes VARCHAR, O % since 1856 VARCHAR) CREATE TABLE olympians (olympians_id AUTO_INCREMENT PRIMARY KEY, Last VARCHAR, First VARCHAR, Year INT, Sport VARCHAR, Country VARCHAR) CREATE TABLE onshore_pipelines (onshore_pipelines_id AUTO_INCREMENT PRIMARY KEY, Name (year commissioned) VARCHAR, Owner/operator VARCHAR, Length VARCHAR, Maximum diameter VARCHAR, From/to VARCHAR, Licence number VARCHAR) CREATE TABLE race_1_-_2.01.2010 (race_1_-_2.01.2010_id AUTO_INCREMENT PRIMARY KEY, Position INT, Pilot VARCHAR, Glider VARCHAR, Speed VARCHAR, Distance VARCHAR)  
SELECT Last FROM olympians WHERE Year < 2000 AND Sport = softball