CREATE TABLE table_6942 ("Country" TEXT, "Total population  ( millions ) " FLOAT, "Total Foreign-born  ( millions ) " FLOAT, "Born in other EU state  ( millions ) " FLOAT, "Born in a non EU state  ( millions ) " FLOAT)

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_6942 WHERE "Total Foreign-born (millions)" = '0.5' AND "Total population (millions)" < '5.534'
SELECT AVG("Born in other EU state (millions)") FROM "table_6942" WHERE "Total Foreign-born (millions)" = '0.5' AND "Total population (millions)" < '5.534'