Who are the batting partners for the 1997 season?
CREATE TABLE table_1670921_1 (batting_partners VARCHAR, season VARCHAR)
SELECT batting_partners FROM table_1670921_1 WHERE season = "1997"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1670921_1 (batting_partners VARCHAR, season VARCHAR) Question: Who are the batting partners for the 1997 season? [/INST] SELECT batting_partners FROM table_1670921_1 WHERE season = "1997" </s>