Table: cricket_teams
Columns: year
premier_one
premier_two
bristol_somerset
glos_wilts
bristol_n_som
somerset
gloucestershire
wiltshire

Question: what is the somerset for the  year 2009?
SQL: SELECT "somerset" FROM cricket_teams WHERE "year" = 2009

Question: what is the bristol & n. som where the somerset is ashcott and shapwick?
SQL: SELECT "bristol_n_som" FROM cricket_teams WHERE "somerset" = 'Ashcott and Shapwick'

Question: what is the latest year where glos & wilts is warminster?
SQL: SELECT MAX("year") FROM cricket_teams WHERE "glos_wilts" = 'Warminster'

Question: what is the glos & wilts where the bristol & somerset is lansdown?
SQL: SELECT "glos_wilts" FROM cricket_teams WHERE "bristol_somerset" = 'Lansdown'

Question: what is the year where glos & wilts is gloucester city winget?
SQL: SELECT "year" FROM cricket_teams WHERE "glos_wilts" = 'Gloucester City Winget'

Question: who many times is gloucestershire is painswick?
SQL: SELECT COUNT("premier_two") FROM cricket_teams WHERE "gloucestershire" = 'Painswick'