CREATE TABLE person (name VARCHAR2)
CREATE TABLE Person (name VARCHAR2, job VARCHAR2)
CREATE TABLE PersonFriend (name VARCHAR2, friend VARCHAR2)

Find the name of the person who has no student friends.
SELECT name FROM Person EXCEPT SELECT T2.name FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.friend WHERE T1.job = 'student'
SELECT "name" FROM "Person" EXCEPT SELECT "T2"."name" FROM "Person" "T1" JOIN "PersonFriend" "T2" ON "T1"."name" = "T2"."friend" WHERE "T1"."job" = 'student'