Database: farm
Question: What are the official names of cities that have not hosted a farm competition?
SQL:
SELECT Official_Name FROM city WHERE City_ID NOT IN (SELECT Host_city_ID FROM farm_competition)