Who is the person that has no friend?
create table personfriend (name varchar, PRIMARY KEY (name)); create table person (name varchar, PRIMARY KEY (name))
select name from person except select name from personfriend