user: ### NOW ANSWER:
Question: What is the district for the parish, Brough?
Columns: ['Name', 'Status', 'Population', 'District', 'Former local authority']
Types: ['text', 'text', 'real', 'text', 'text']
Sample row: ['Above Derwent', 'Civil parish', 1207.0, 'Allerdale', 'Cockermouth Rural District']
SQL:

assistant: SELECT "District" FROM "Table" WHERE "Name" = 'Brough';