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 número total de jogadores onde os anos para rockets são 1975-79
 ###Tabelas: CREATE TABLE table_presidential_elections (table_presidential_elections_id AUTO_INCREMENT PRIMARY KEY, Election VARCHAR, Candidate VARCHAR, Number of votes VARCHAR, Share of votes VARCHAR, Outcome of election VARCHAR) CREATE TABLE european_version (european_version_id AUTO_INCREMENT PRIMARY KEY, Song title VARCHAR, Artist VARCHAR, Language VARCHAR, Decade VARCHAR, Genre VARCHAR, Exportable VARCHAR, Family Friendly VARCHAR) CREATE TABLE allowable_tackle_types (allowable_tackle_types_id AUTO_INCREMENT PRIMARY KEY, sliding tackle VARCHAR, spear tackle VARCHAR, dump tackle VARCHAR, body tackle VARCHAR, ankle tap VARCHAR, diving tackle VARCHAR, bumping/blocking VARCHAR, shoulder charge VARCHAR, steal/intercept ball VARCHAR, Chicken wing VARCHAR) CREATE TABLE w (w_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, No.(s) VARCHAR, Height in Ft. VARCHAR, Position VARCHAR, Years for Rockets VARCHAR, School/Club Team/Country VARCHAR) CREATE TABLE list_of_agriculture_ministers (list_of_agriculture_ministers_id AUTO_INCREMENT PRIMARY KEY, Order VARCHAR, Minister VARCHAR, Party VARCHAR, Prime Minister VARCHAR, Title VARCHAR, Term start VARCHAR, Term end VARCHAR, Term in office VARCHAR)  
SELECT COUNT Player FROM w WHERE Years for Rockets = 1975-79