Show me the names of all cities
select official_name from city
How many competitions did these cities host?
select t1.official_name, count(*) from city as t1 join farm_competition as t2 on t1.city_id = t2.host_city_id group by city_id
Which of these cities hosted the most competitions?
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 order by count(*) desc limit 1
Can you only show me its status?
select t1.status from city as t1 join farm_competition as t2 on t1.city_id = t2.host_city_id group by t2.host_city_id order by count(*) desc limit 1