Table schema:
CREATE TABLE table_name_58 (district VARCHAR, name VARCHAR)

Question: What is the district for the parish, Brough?
SQL: SELECT district FROM table_name_58 WHERE name = "brough"