Which cities have populations larger than 1000? List their ids.
SELECT city_id FROM city WHERE population > 1000
cities with populations larger than 1000 refers to population > 1000; listing their ids refers to SELECT city_id;