Who is the person that has no friend?
select name from person except select name from personfriend
What is the job occupation of Zach?
select job from person where name = 'Zach'