user: Question: who many times is gloucestershire is Painswick?
Columns: ['Year', 'Premier One', 'Premier Two', 'Bristol & Somerset', 'Glos & Wilts', 'Bristol & N. Som', 'Somerset', 'Gloucestershire', 'Wiltshire']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [2007.0, 'Frocester', 'Downend', 'Lansdown', 'Warminster', 'Winterbourne', 'Winscombe', 'Rockhampton', 'Wootton Bassett']
SQL:

assistant: SELECT COUNT("Premier Two") FROM "Table" WHERE "Gloucestershire" = 'Painswick';