Show me the official names of the cities that have 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
Show me the official names of the cities that have hosted only 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
What were the themes of each of those competitions?
select t1.official_name, t2.theme 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
What is the census rating of the city with the official name "Plaster Rock"?
select t1.census_ranking from city as t1 join farm_competition as t2 on t1.city_id = t2.host_city_id where t1.official_name = "Plaster Rock"
What is the census rating of the city that hosted the competition with the theme "Carnival M is back!"?
select t1.census_ranking from city as t1 join farm_competition as t2 on t1.city_id = t2.host_city_id where t2.theme = "Carnival m is back!"