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: Quem são os parceiros de rebatida para a temporada de 1997?
 ###Tabelas: CREATE TABLE members_of_parliament (members_of_parliament_id AUTO_INCREMENT PRIMARY KEY, Election VARCHAR, 1st Member VARCHAR, 1st Party VARCHAR, 2nd Member VARCHAR, 2nd Party VARCHAR, 3rd Member VARCHAR, 3rd Party VARCHAR) CREATE TABLE timeline_of_tallest_buildings_and_structures (timeline_of_tallest_buildings_and_structures_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Location VARCHAR, Years as tallest VARCHAR, Height metres / ft VARCHAR, Floors VARCHAR) CREATE TABLE test_record_partnerships_by_wicket (test_record_partnerships_by_wicket_id AUTO_INCREMENT PRIMARY KEY, Wicket VARCHAR, Runs INT, Batting partners VARCHAR, Batting team VARCHAR, Fielding team VARCHAR, Venue VARCHAR, Season VARCHAR) CREATE TABLE list_of_provinces (list_of_provinces_id AUTO_INCREMENT PRIMARY KEY, Region VARCHAR, Province VARCHAR, Capital VARCHAR, No. of Communes INT, Area INT, 2002 Population INT) CREATE TABLE calendar (calendar_id AUTO_INCREMENT PRIMARY KEY, Round INT, Circuit VARCHAR, Date VARCHAR, Pole Position VARCHAR, Fastest Lap VARCHAR, Winning Driver VARCHAR, Winning Team VARCHAR)  
SELECT Batting partners FROM test_record_partnerships_by_wicket WHERE Season = 1997