user: ### NOW ANSWER:
Question: What is the Redcliffe population with a Pine Rivers population greater than 164254 and a total population less than 103669?
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 SUM("(Redcliffe)") FROM "Table" WHERE "(Pine Rivers)" > 164254.0 AND "Population (Total)" < 103669.0;