I am trying to find capitals with a population between 200,000 and 300,000 and I do not know how to build the query correctly. Here is what I have, but it doesn't work:

enter image description here


2 Answers 2


use the query below, you need to identify pop2007 field in 2nd parameter

POP2007 >=20000 and POP2009 <= 30000

You could also use this query as long as it is not a STRING:

POP2007 BETWEEN 20000 AND 30000

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.