user: Question: How many people in Stanthorpe had a population matching Rosenthan of 1553 and a population greater than 25917?
Columns: ['Year', 'Population (Region total)', 'Population (Stanthorpe)', 'Population (Warwick)', 'Population (Allora)', 'Population (Glengallan)', 'Population (Rosenthal)']
Types: ['real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: [1933.0, 25016.0, 6934.0, 6664.0, 2624.0, 6334.0, 2460.0]
SQL:

assistant: SELECT COUNT("Population (Stanthorpe)") FROM "Table" WHERE "Population (Rosenthal)" = 1553.0 AND "Population (Region total)" > 25917.0;