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 "population" (
  "year" real,
  "population_total" real,
  "caboolture" real,
  "pine_rivers" real,
  "redcliffe" real
);
SELECT AVG("caboolture") FROM "population" WHERE "redcliffe">'27,327' AND "pine_rivers">'119,236' AND "year">1971 AND "population_total">'344,878';