What is the total population of Rosenthal that's less than 24,300 for the population and has a population for Glengallan less than 3,410?
CREATE TABLE "population" (
  "year" real,
  "population_region_total" real,
  "population_stanthorpe" real,
  "population_warwick" real,
  "population_allora" real,
  "population_glengallan" real,
  "population_rosenthal" real
);
SELECT SUM("population_rosenthal") FROM "population" WHERE "population_region_total"<'24,300' AND "population_glengallan"<'3,410';