human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Year, Premier One, Premier Two, Bristol & Somerset, Glos & Wilts, Bristol & N. Som, Somerset, Gloucestershire, Wiltshire
###Question: who many times is gloucestershire is painswick?
gpt
SELECT COUNT Premier Two FROM table WHERE Gloucestershire = Painswick