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 Registro, quando o Oponente é "New York Knicks"?
 ###Tabelas: CREATE TABLE classification_leadership (classification_leadership_id AUTO_INCREMENT PRIMARY KEY, Stage VARCHAR, Winner VARCHAR, General classification VARCHAR, Points classification VARCHAR, Mountains classification VARCHAR, Young rider classification VARCHAR, Trofeo Fast Team VARCHAR) CREATE TABLE variation_with_playing_cards (variation_with_playing_cards_id AUTO_INCREMENT PRIMARY KEY, 1st player's choice VARCHAR, 2nd player's choice VARCHAR, Probability 1st player wins VARCHAR, Probability 2nd player wins VARCHAR, Probability of a draw VARCHAR) CREATE TABLE most_valuable_player_award_winners (most_valuable_player_award_winners_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Winner VARCHAR, Team VARCHAR, Position VARCHAR, Win # INT) CREATE TABLE the_reform_of_the_national_water_and_sewerage_corporation (the_reform_of_the_national_water_and_sewerage_corporation_id AUTO_INCREMENT PRIMARY KEY, 1998 VARCHAR, 2000 VARCHAR, 2004 VARCHAR, 2007 VARCHAR, 2011 VARCHAR) CREATE TABLE season_schedule (season_schedule_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Opponent VARCHAR, Score VARCHAR, Result VARCHAR, Record VARCHAR)  
SELECT Record FROM season_schedule WHERE Opponent = new york knicks