user: Question: Who are the batting partners for the 1997 season?
Columns: ['Wicket', 'Runs', 'Batting partners', 'Batting team', 'Fielding team', 'Venue', 'Season']
Types: ['text', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1st', 415.0, 'GC Smith and Neil McKenzie', 'South Africa', 'Bangladesh', 'Chittagong', '2008']
SQL:

assistant: SELECT "Batting partners" FROM "Table" WHERE "Season" = '1997';