SELECT T2.friend FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.name WHERE T1.name = 'Bob'
Who are the friends of Bob?
CREATE TABLE PersonFriend (
    friend VARCHAR,
    name VARCHAR
)

CREATE TABLE Person (
    name VARCHAR
)