CREATE TABLE person (name TEXT, age DECIMAL, city TEXT, gender TEXT, job TEXT)
CREATE TABLE personfriend (name TEXT, friend TEXT, year DECIMAL)

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"