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

Question: What is the batting team where the runs are 276?
SQL: SELECT "batting_team" FROM batting_stats WHERE "runs" = '276'

Question: Name the batting team at Durham
SQL: SELECT "batting_team" FROM batting_stats WHERE "fielding_team" = 'Durham'

Question: What is the batting team with the batting partnets of thilina kandamby and rangana herath?
SQL: SELECT "batting_team" FROM batting_stats WHERE "batting_partners" = 'Thilina Kandamby and Rangana Herath'

Question: What is the fielding team with 155 runs?
SQL: SELECT "fielding_team" FROM batting_stats WHERE "runs" = '155'

Question: What is the batting partners with runs of 226?
SQL: SELECT "batting_partners" FROM batting_stats WHERE "runs" = '226'