What is the greatest Rosenthal poulation for a region that has 30,554 people and a Glegallan population less than 4,088?
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 MAX("population_rosenthal") FROM "population" WHERE "population_region_total"='30,554' AND "population_glengallan"<'4,088';