List all the city names.
select official_name from city
Can you also show me the competition id of these cities?
select t1.official_name, t2.competition_id from city as t1 join farm_competition as t2 on t1.city_id = t2.host_city_id
How about the themes of these competitions?
select t1.official_name, t2.theme from city as t1 join farm_competition as t2 on t1.city_id = t2.host_city_id
Which of these cities hosted more than one competition?
select t1.official_name from city as t1 join farm_competition as t2 on t1.city_id = t2.host_city_id group by t2.host_city_id having count(*) > 1