Table: immigration_eu
Columns: country
total_population_millions
total_foreign_born_millions
born_in_other_eu_state_millions
born_in_a_non_eu_state_millions

Question: What was the lowest number of Total Foreign-born (millions) people, when the number of people Born in a non EU state (millions) was 6.415?
SQL: SELECT MIN("total_foreign_born_millions") FROM immigration_eu WHERE "born_in_a_non_eu_state_millions" = 6.415

Question: What was the average number of people born in other EU states in millions, when the total number of foreign-born people in millions was 0.5, and when the total population in millions was less than 5.534?
SQL: SELECT AVG("born_in_other_eu_state_millions") FROM immigration_eu WHERE "total_foreign_born_millions" = 0.5 AND "total_population_millions" < 5.534

Question: What was the average number of people born in other EU states in millions, when the number of people born in a non EU state in millions was 31.368, and when the total population in millions was higher than 501.098?
SQL: SELECT AVG("born_in_other_eu_state_millions") FROM immigration_eu WHERE "born_in_a_non_eu_state_millions" = 31.368 AND "total_population_millions" > 501.098

Question: How many people were born in a non EU state (in millions), when the Total population (in millions) was 62.008?
SQL: SELECT "born_in_a_non_eu_state_millions" FROM immigration_eu WHERE "total_population_millions" = 62.008