user: ### NOW ANSWER:
Question: what is the bristol & n. som where the somerset is Ashcott and Shapwick?
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 "Bristol & N. Som" FROM "Table" WHERE "Somerset" = 'Ashcott and Shapwick';