Table: immigration_eu_uk
Columns: country
total_population_1000
total_foreign_born_1000
born_in_other_eu_state_1000
born_in_a_non_eu_state_1000

Question: How many Foreign-born (1000) are from Sweden and born in some other EU state (1000) larger than 477?
SQL: SELECT SUM("total_foreign_born_1000") FROM immigration_eu_uk WHERE "country" = 'sweden' AND "born_in_other_eu_state_1000" > 477

Question: What is the greatest Total population (1000) from Sweden and born in a non EU state (1000) less than 859?
SQL: SELECT MAX("total_population_1000") FROM immigration_eu_uk WHERE "country" = 'sweden' AND "born_in_a_non_eu_state_1000" < 859