user: ### NOW ANSWER:
Question: What is the Pine Rivers total population after 1947 with a Redcliffe population smaller than 68877, a total population greater than 50785, and a Caboolture population greater than 12207?
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 COUNT("(Pine Rivers)") FROM "Table" WHERE "Year" > 1947.0 AND "(Redcliffe)" < 68877.0 AND "Population (Total)" > 50785.0 AND "(Caboolture)" > 12207.0;