Table: cricket_partnership_2
Columns: runs
wicket
batting_partners
batting_team
fielding_team
venue
season

Question: How many total batting partners were most successful in the 2006 season?
SQL: SELECT COUNT("batting_partners") FROM cricket_partnership_2 WHERE "season" = '2006'

Question: What batting partners batted for pakistan?
SQL: SELECT "batting_partners" FROM cricket_partnership_2 WHERE "batting_team" = 'Pakistan'

Question: How many runs when bangladesh was the fielding team?
SQL: SELECT "runs" FROM cricket_partnership_2 WHERE "fielding_team" = 'Bangladesh'

Question: What are the wickets when there are 451 runs and india is the fielding team?
SQL: SELECT "wicket" FROM cricket_partnership_2 WHERE "runs" = '451' AND "fielding_team" = 'India'

Question: What batting partners played in sydney?
SQL: SELECT "batting_partners" FROM cricket_partnership_2 WHERE "venue" = 'Sydney'

Question: What batting partners were the most successful in 2004?
SQL: SELECT "batting_partners" FROM cricket_partnership_2 WHERE "season" = '2004'