SELECT Official_Name FROM city WHERE City_ID NOT IN (SELECT Host_city_ID FROM farm_competition)
What are the official names of cities that have not hosted a farm competition?
SELECT Official_Name FROM city WHERE City_ID NOT IN ( SELECT Host_city_ID FROM farm_competition )
select official_name from city where city_id not in ( select host_city_id from farm_competition )
What are the official names of cities that have not hosted a farm competition ?