Table: ethnic_population_over_time
Columns: ethnic_group
2001_population
2001
2011_population
2011

Question: What is the highest 2001 population when the ethnic group is white: british?
SQL: SELECT MAX("2001_population") FROM ethnic_population_over_time WHERE "ethnic_group" = 'White: British'

Question: What is the ethnic group when the 2011 % is 2.0?
SQL: SELECT "ethnic_group" FROM ethnic_population_over_time WHERE "2011" = '2.0'

Question: How many times is the ethnic group other: total?
SQL: SELECT COUNT("2001") FROM ethnic_population_over_time WHERE "ethnic_group" = 'Other: Total'

Question: How many times is the 2001 population 237810?
SQL: SELECT COUNT("2011_population") FROM ethnic_population_over_time WHERE "2001_population" = 237810

Question: What is the highest 2011 population when the ethnic group is asian or asian british: asian other?
SQL: SELECT MAX("2011_population") FROM ethnic_population_over_time WHERE "ethnic_group" = 'Asian or Asian British: Asian Other'