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 jogador estava ativo no Jazz de 1975 a 1979?
 ###Tabelas: CREATE TABLE appearances_in_tour_de_france (appearances_in_tour_de_france_id AUTO_INCREMENT PRIMARY KEY, Year INT, Stage INT, Category VARCHAR, Start VARCHAR, Finish VARCHAR, Leader at the summit VARCHAR) CREATE TABLE popular_languages_used_for_data_exchange (popular_languages_used_for_data_exchange_id AUTO_INCREMENT PRIMARY KEY, Schemas VARCHAR, Flexible VARCHAR, Semantic verification VARCHAR, Dictionary VARCHAR, Information Model VARCHAR, Synonyms and homonyms VARCHAR, Dialecting VARCHAR, Web standard VARCHAR, Transformations VARCHAR, Lightweight VARCHAR, Human readable VARCHAR) CREATE TABLE end-of-season_managerial_changes (end-of-season_managerial_changes_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Club VARCHAR, Date of departure VARCHAR, Replacement VARCHAR, Date of appointment VARCHAR) CREATE TABLE atlantic_coast_conference_10–3–1 (atlantic_coast_conference_10–3–1_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Wins INT, Loss INT, Home Wins INT, Home Losses INT, Away Wins INT, Away Losses INT, Neutral Wins INT, Neutral Losses INT) CREATE TABLE m (m_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Nationality VARCHAR, Position VARCHAR, Years for Jazz VARCHAR, School/Club Team VARCHAR)  
SELECT Player FROM m WHERE Years for Jazz = 1975-79