What is the highest Rank, when Date of Official Foundation of Municipality is "1952", and when 2006 is less than 189120?
CREATE TABLE "cities_between_100_000_and_1_000_000_pop" (
  "rank" real,
  "city" text,
  "province" text,
  "date_of_official_foundation_of_municipality" real,
  "2006" real
);
SELECT MAX("rank") FROM "cities_between_100_000_and_1_000_000_pop" WHERE "date_of_official_foundation_of_municipality"=1952 AND "2006"<189120;