user: Question: What is the total population of Rosenthal that's less than 24300 for the population and has a population for Glengallan less than 3410?
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 SUM("Population (Rosenthal)") FROM "Table" WHERE "Population (Region total)" < 24300.0 AND "Population (Glengallan)" < 3410.0;