What are the names of Bob's friends?
SELECT friend from personfriend where name  =  "Bob"
names of Bob's friends refers to SELECT statement on friend column; condition for Bob's friends refers to WHERE name = 'Bob';