user: ### NOW ANSWER:
Question: What is the highest Rank, when Date of Official Foundation of Municipality is "1952", and when 2006 is less than 189120?
Columns: ['Rank', 'City', 'Province', 'Date of Official Foundation of Municipality', '2006']
Types: ['real', 'text', 'text', 'real', 'real']
Sample row: [7.0, 'Ahvaz', 'Khūzestān', 1925.0, 969843.0]
SQL:

assistant: SELECT MAX("Rank") FROM "Table" WHERE "Date of Official Foundation of Municipality" = 1952.0 AND "2006" < 189120.0;