Table: core_cities_group
Columns: city
county
region
local_authority
type
population
urban_area
metropolitan_area

Question: The city of Birmingham is what type of location?
SQL: SELECT "type" FROM core_cities_group WHERE "city" = 'Birmingham'

Question: Leeds City Council is the local authority for what type of location?
SQL: SELECT "type" FROM core_cities_group WHERE "local_authority" = 'Leeds City Council'

Question: Tyne and Wear County has what total membership for their metropolitan area?
SQL: SELECT "metropolitan_area" FROM core_cities_group WHERE "county" = 'Tyne and Wear'

Question: What is the total membership for the metropolitan area in the city of Manchester?
SQL: SELECT MAX("metropolitan_area") FROM core_cities_group WHERE "city" = 'Manchester'