Table: above_derwent
Columns: name
status
population
district
former_local_authority

Question: What district is the parish Milburn in?
SQL: SELECT "district" FROM above_derwent WHERE "name" = 'milburn'

Question: What is the population of the Parish, Plumbland, that had a former local authority of Cockermouth Rural District?
SQL: SELECT COUNT("population") FROM above_derwent WHERE "former_local_authority" = 'cockermouth rural district' AND "name" = 'plumbland'

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