Show me the information for all of the cities.
select * from city
Which of these cities have a population greater than 1000?
select * from city where population > 1000
Show me all the years when a competition was held in these cities.
select t2.year from city as t1 join farm_competition as t2 on t1.city_id = t2.host_city_id where population > 1000
What about the themes of these competitions?
select t2.theme from city as t1 join farm_competition as t2 on t1.city_id = t2.host_city_id where t1.population > 1000