Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE farm_competition (Host_city_ID VARCHAR)
TABLE: CREATE TABLE city (Official_Name VARCHAR, City_ID VARCHAR)

### Question ###
Show the official names of the cities that have hosted more than one competition.

### Accurate SQL ###

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