user: ### NOW ANSWER:
Question: How many total batting partners were most successful in the 2006 season?
Columns: ['Runs', 'Wicket', 'Batting partners', 'Batting team', 'Fielding team', 'Venue', 'Season']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['624', '3rd', 'Mahela Jayawardene and Kumar Sangakkara', 'Sri Lanka', 'South Africa', 'Colombo', '2006']
SQL:

assistant: SELECT COUNT("Batting partners") FROM "Table" WHERE "Season" = '2006';