human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Rank, County, Population (1960), Population (2000), Population (2040)
###Question: What was the population of a county in 1960 that had a population of 467,052 in 2000 and 78,812 in 2040?
gpt
SELECT AVG Population (1960) FROM table WHERE Population (2000) > 467,052 AND Population (2040) = 78,812