What is the average Caboolture population with a Redcliffe population greater than 27,327, a Pine Rivers population greater than 119,236, and a total population greater than 344,878 after 1971?
CREATE TABLE table_71058 (
    "Year" real,
    "Population (Total)" real,
    "(Caboolture)" real,
    "(Pine Rivers)" real,
    "(Redcliffe)" real
)
SELECT AVG("(Caboolture)") FROM table_71058 WHERE "(Redcliffe)" > '27,327' AND "(Pine Rivers)" > '119,236' AND "Year" > '1971' AND "Population (Total)" > '344,878'
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 is the average Caboolture population with a Redcliffe population greater than 27,327, a Pine Rivers population greater than 119,236, and a total population greater than 344,878 after 1971? ### Input: CREATE TABLE table_71058 (
    "Year" real,
    "Population (Total)" real,
    "(Caboolture)" real,
    "(Pine Rivers)" real,
    "(Redcliffe)" real
) ### Response: SELECT AVG("(Caboolture)") FROM table_71058 WHERE "(Redcliffe)" > '27,327' AND "(Pine Rivers)" > '119,236' AND "Year" > '1971' AND "Population (Total)" > '344,878'