What was the population of a county in 1960 that had a population of 467,052 in 2000 and 78,812 in 2040?
CREATE TABLE table_74648 (
    "Rank" text,
    "County" text,
    "Population (1960)" real,
    "Population (2000)" real,
    "Population (2040)" real
)
SELECT AVG("Population (1960)") FROM table_74648 WHERE "Population (2000)" > '467,052' AND "Population (2040)" = '78,812'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What was the population of a county in 1960 that had a population of 467,052 in 2000 and 78,812 in 2040? ### Input: CREATE TABLE table_74648 (
    "Rank" text,
    "County" text,
    "Population (1960)" real,
    "Population (2000)" real,
    "Population (2040)" real
) ### Response: SELECT AVG("Population (1960)") FROM table_74648 WHERE "Population (2000)" > '467,052' AND "Population (2040)" = '78,812'