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: Quantos gols de campo tiveram 597 pontos?
 ###Tabelas: CREATE TABLE record_by__conference (record_by__conference_id AUTO_INCREMENT PRIMARY KEY, Conference VARCHAR, # of Bids INT, Record VARCHAR, Win % VARCHAR, Round of 32 VARCHAR, Sweet Sixteen VARCHAR, Elite Eight VARCHAR, Final Four VARCHAR, Championship Game VARCHAR) CREATE TABLE other (other_id AUTO_INCREMENT PRIMARY KEY, Index (Year) VARCHAR, Author / Editor / Source VARCHAR, Year of publication VARCHAR, Countries sampled INT, World Ranking (1) VARCHAR, Ranking L.A. (2) VARCHAR) CREATE TABLE player_stats (player_stats_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Minutes INT, Field Goals INT, Rebounds INT, Assists INT, Steals INT, Blocks INT, Points INT) CREATE TABLE diesel_locomotives (diesel_locomotives_id AUTO_INCREMENT PRIMARY KEY, Number VARCHAR, Builder VARCHAR, Type VARCHAR, Date VARCHAR, Works number VARCHAR) CREATE TABLE member_teams (member_teams_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Location VARCHAR, Founded INT, Affiliation VARCHAR, Enrollment INT, Team Nickname VARCHAR, Primary conference VARCHAR, Home Rink VARCHAR)  
SELECT COUNT Field Goals FROM player_stats WHERE Points = 597