SELECT Name FROM HOST WHERE Host_ID NOT IN (SELECT Host_ID FROM party_host)
What are the names of hosts who did not host any party in our record?
SELECT Name FROM HOST WHERE Host_ID NOT IN ( SELECT Host_ID FROM party_host )
select name from host where host_id not in ( select host_id from party_host )
What are the names of hosts who did not host any party in our record ?