CREATE TABLE table_name_58 (district VARCHAR, name VARCHAR)

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