Hello, could you find how many friends Alice has?
select count ( * ) from personfriend where name = 'Alice'
What is the name of Alice's friend?
select friend from personfriend where name = "Alice"
What are the names of Bob's friends?
select friend from personfriend where name = "Bob"
Is Zach also a male?
select gender from person where name = "Zach"