user: ### NOW ANSWER:
Question: When 142900 is the population what is the highest rank?
Columns: ['Rank', 'City/Town', 'County', 'Region/Province', 'Population', 'Country']
Types: ['real', 'text', 'text', 'text', 'real', 'text']
Sample row: [1.0, 'Dublin', 'County Dublin', 'Leinster', 505739.0, 'Republic of Ireland']
SQL:

assistant: SELECT MAX("Rank") FROM "Table" WHERE "Population" = 142900.0;