CREATE TABLE table_39466 ("Name" CLOB, "Status" CLOB, "Population" FLOAT, "District" CLOB, "Former local authority" CLOB)

What is the district for the parish, Brough?
SELECT "District" FROM table_39466 WHERE "Name" = 'brough'
SELECT "District" FROM "table_39466" WHERE "Name" = 'brough'