Table: postsov_aliyah_stats
Columns: year
births_000s
deaths
natural_growth
total_fertility_rate

Question: What is the average birth rate that has a total fertility rate of na, and a natural growth smaller than 2.5?
SQL: SELECT AVG("births_000s") FROM postsov_aliyah_stats WHERE "total_fertility_rate" = 'na' AND "natural_growth" < 2.5

Question: What was the amount of deaths that had a natural growth smaller than 3.4, and a total fertility rate of 1.63?
SQL: SELECT "deaths" FROM postsov_aliyah_stats WHERE "natural_growth" < 3.4 AND "total_fertility_rate" = '1.63'

Question: What is the average births that had a death rate of 0.4
SQL: SELECT AVG("births_000s") FROM postsov_aliyah_stats WHERE "deaths" = 0.4

Question: What was the amount of Births (000s) that had a death rate larger than 7.6, and a Year of 1990-2009?
SQL: SELECT SUM("births_000s") FROM postsov_aliyah_stats WHERE "deaths" > 7.6 AND "year" = '1990-2009'

Question: What was the total fertility rate that had a death rate larger than 7.8?
SQL: SELECT "total_fertility_rate" FROM postsov_aliyah_stats WHERE "deaths" > 7.8