user: ### NOW ANSWER:
Question: What is the average Caboolture population with a Redcliffe population greater than 27327, a Pine Rivers population greater than 119236, and a total population greater than 344878 after 1971?
Columns: ['Year', 'Population (Total)', '(Caboolture)', '(Pine Rivers)', '(Redcliffe)']
Types: ['real', 'real', 'real', 'real', 'real']
Sample row: [1933.0, 11928.0, 5316.0, 4604.0, 2008.0]
SQL:

assistant: SELECT AVG("(Caboolture)") FROM "Table" WHERE "(Redcliffe)" > 27327.0 AND "(Pine Rivers)" > 119236.0 AND "Year" > 1971.0 AND "Population (Total)" > 344878.0;