Database: farm
Question: List the official names of cities that have not held any competition.
SQL:
SELECT Official_Name FROM city WHERE City_ID NOT IN (SELECT Host_city_ID FROM farm_competition)