Table:
text: Moreton Bay Region
Population
Population
Year_ Population_Total Caboolture Pine_Rivers Redcliffe
1933 11928 5316 4604 2008
1947 19402 5716 4815 8871
1954 27267 7101 6309 13857
1961 39312 8877 8761 21674
1966 50785 10149 13309 27327
1971 72955 12207 26187 34561
1976 103669 19404 45192 39073
1981 133056 32644 58189 42223
1986 166210 47494 73783 44933
1991 205743 70052 87892 47799
1996 250077 98859 103192 48026
2001 280765 112458 119236 49071
2005 325067 123129 137018 64921
2007 344878 130633 145368 68877
2009 371155 140586 156444 74125
2011 389684 147604 164254 77826

Question: What is Redcliffe population with Pine Rivers population greater than 164,254 and total population less than 103,669 in the Moreton Bay area?

Question: What is the total population of Pine Rivers in the Moreton Bay region after 1947 with a Redcliffe population less than 68,877, a total population greater than 50,785 and a Caboolture population greater than 12,207?

Question: 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 post-1971 population greater than 344,878 in the Moreton Bay area?