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 dos jogadores da carreira do Real Betis teve menos de 98 aparições, nacionalidade da Espanha, e mais de 15 gols?
 ###Tabelas: CREATE TABLE notable_players (notable_players_id AUTO_INCREMENT PRIMARY KEY, Nationality VARCHAR, Position VARCHAR, Real Betis career VARCHAR, Appearances INT, Goals INT) CREATE TABLE diesel_multiple_units (diesel_multiple_units_id AUTO_INCREMENT PRIMARY KEY, Type VARCHAR, Numbers VARCHAR, Year built INT, Quantity built VARCHAR, Power (horsepower) INT, Max Speed (km/h) INT) CREATE TABLE double_titles_5 (double_titles_5_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE by_teams (by_teams_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Winners INT, Runners-up INT, Years won VARCHAR, Years runners-up VARCHAR) CREATE TABLE list_of_the_most_populous_us_counties_sorted_according_to_the_mid-2011_official_estimate_by_the_uscb (list_of_the_most_populous_us_counties_sorted_according_to_the_mid-2011_official_estimate_by_the_uscb_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, County VARCHAR, State VARCHAR, Land area (km²) VARCHAR, Land area (mi²) VARCHAR, April 1, 2010 census VARCHAR, April 1, 2010 density (/km²) VARCHAR, April 1, 2010 density (/mi²) VARCHAR, July 1, 2010 official estimate VARCHAR, July 1, 2010 density (/km²) VARCHAR, July 1, 2010 density (/mi²) VARCHAR, July 1, 2011 official estimate VARCHAR, July 1, 2011 density (/km²) VARCHAR, July 1, 2011 density (/mi²) VARCHAR, Mid-2010 to mid-2011 change (Absolute) VARCHAR, Mid-2010 to mid-2011 change (%) VARCHAR, County seat or courthouse VARCHAR)  
SELECT Real Betis career FROM notable_players WHERE Appearances < 98 AND Nationality = spain AND Goals > 15