CREATE TABLE farm_competition (competition_id NUMBER, year NUMBER, theme CLOB, host_city_id NUMBER, hosts CLOB)
CREATE TABLE farm (farm_id NUMBER, year NUMBER, total_horses NUMBER, working_horses NUMBER, total_cattle NUMBER, oxen NUMBER, bulls NUMBER, cows NUMBER, pigs NUMBER, sheep_and_goats NUMBER)
CREATE TABLE city (city_id NUMBER, official_name CLOB, status CLOB, area_km_2 NUMBER, population NUMBER, census_ranking CLOB)
CREATE TABLE competition_record (competition_id NUMBER, farm_id NUMBER, rank NUMBER)

What is the status of the city that has hosted the most 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
SELECT "T1"."status" FROM "city" "T1" JOIN "farm_competition" "T2" ON "T1"."city_id" = "T2"."host_city_id" GROUP BY "T2"."host_city_id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY