CREATE TABLE table_name_57 (born_in_other_eu_state__millions_ NUMBER, total_foreign_born__millions_ VARCHAR2, total_population__millions_ VARCHAR2)

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?
SELECT AVG(born_in_other_eu_state__millions_) FROM table_name_57 WHERE total_foreign_born__millions_ = 0.5 AND total_population__millions_ < 5.534
SELECT AVG("born_in_other_eu_state__millions_") FROM "table_name_57" WHERE "total_foreign_born__millions_" = 0.5 AND "total_population__millions_" < 5.534