user: ### NOW ANSWER:
Question: What was the population of a county in 2040 that had a population less than 108172 in 2000 and less than 107589 in 1960?
Columns: ['Rank', 'County', 'Population (1960)', 'Population (2000)', 'Population (2040)']
Types: ['text', 'text', 'real', 'real', 'real']
Sample row: ['1', 'Oslo', 471511.0, 507467.0, 823549.0]
SQL:

assistant: SELECT COUNT("Population (2040)") FROM "Table" WHERE "Population (1960)" < 108172.0 AND "Population (2000)" < 107589.0;