Which cities have populations larger than 1000? List their ids.
select city_id from city where population > 1000
Which cities have populations less than 1000? List their ids.
select distinct t1.city_id from city as t1 join farm_competition as t2 on t1.city_id = t2.host_city_id where t1.population < 1000