Can you give me the name of the counties with population between 50000 and 100000?
SELECT County_name FROM county WHERE Population  <  100000 AND Population  >  50000
counties with population between 50000 and 100000 refers to Population > 50000 AND Population < 100000;