Table: borough_population_trends
Columns: borough
1970
1980
1990
2000
2006

Question: What was the percentage in 2006 that had less than 9% in 1970?
SQL: SELECT AVG("2006") FROM borough_population_trends WHERE "1970" < 9

Question: What was the percentage in 1980 that had less than 37.8% in 2006, more than 29.4% in 2000, and more than 18.2% in 1970?
SQL: SELECT MIN("1980") FROM borough_population_trends WHERE "2006" < 37.8 AND "2000" > 29.4 AND "1970" > 18.2

Question: What was the percentage in 1980 in Brooklyn?
SQL: SELECT MIN("1980") FROM borough_population_trends WHERE "borough" = 'brooklyn'