user: ### NOW ANSWER:
Question: Who were the batting partners that played for India in 1997?
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 "Fielding team" = 'India' AND "Season" = '1997';