user: ### NOW ANSWER:
Question: What was the population of a county in 1960 that had a population of 467052 in 2000 and 78812 in 2040?
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 AVG("Population (1960)") FROM "Table" WHERE "Population (2000)" > 467052.0 AND "Population (2040)" = 78812.0;