Table: third_div_2008
Columns: team
stadium
capacity
highest
lowest
average

Question: what's the capacity with team being berwick rangers
SQL: SELECT "capacity" FROM third_div_2008 WHERE "team" = 'Berwick Rangers'

Question: what's the team with stadium being borough briggs
SQL: SELECT "team" FROM third_div_2008 WHERE "stadium" = 'Borough Briggs'

Question: what is the maximum lowest with average being 734
SQL: SELECT MAX("lowest") FROM third_div_2008 WHERE "average" = 734

Question:  how many highest with team being forfar athletic
SQL: SELECT COUNT("highest") FROM third_div_2008 WHERE "team" = 'Forfar Athletic'