CREATE TABLE person (name VARCHAR)
CREATE TABLE PersonFriend (name VARCHAR)

Who is the person that has no friend?
SELECT name FROM person EXCEPT SELECT name FROM PersonFriend
SELECT "name" FROM "person" EXCEPT SELECT "name" FROM "PersonFriend"