text: CREATE TABLE farm_competition (Host_city_ID VARCHAR); CREATE TABLE city (Official_Name VARCHAR, City_ID VARCHAR) -- Show 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 CREATE TABLE city (Status VARCHAR, City_ID VARCHAR); CREATE TABLE farm_competition (Host_city_ID VARCHAR) -- Show the status of the city that has hosted the greatest number of competitions. 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 CREATE TABLE city (City_ID VARCHAR, Population INTEGER); CREATE TABLE farm_competition (Theme VARCHAR, Host_city_ID VARCHAR) -- Please show the themes of competitions with host cities having populations larger than 1000. SELECT T2.Theme FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID = T2.Host_city_ID WHERE T1.Population > 1000 CREATE TABLE city (Status VARCHAR, Population INTEGER) -- Please show the different statuses of cities and the average population of cities with each status. SELECT Status, AVG(Population) FROM city GROUP BY Status CREATE TABLE city (Status VARCHAR) -- Please show the different statuses, ordered by the number of cities that have each. SELECT Status FROM city GROUP BY Status ORDER BY COUNT(*)