Which delegates are from countries with population smaller than 100000?
select t2.delegate from county as t1 join election as t2 on t1.county_id = t2.district where t1.population < 100000
Can you give the name of the countries with population smaller than 100000?
select county_name from county where population < 100000
What is the number of counties with population greater than 100000?
select count ( county_name ) from county where population > 100000
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
What are the committee names for the counties with population smaller than 100000?
select t2.committee from county as t1 join election as t2 on t1.county_id = t2.district where t1.population < 100000
What are the committee names for the counties with population between 50000-100000?
select t2.committee from county as t1 join election as t2 on t1.county_id = t2.district where t1.population < 100000 and t1.population > 50000