sqlite> SELECT P1.name, P2.name
   ...> FROM person P1
   ...> JOIN friend F ON P1.id = F.person
   ...> JOIN person P2 ON F.friend = P2.id
   ...> WHERE P1.id IN (
   ...>   SELECT F.friend
   ...>   FROM person P
   ...>   JOIN friend F ON P.id = F.person
   ...>   WHERE P.id IN (
   ...>     SELECT F.friend
   ...>     FROM person P
   ...>     JOIN friend F ON P.id = F.person
   ...>     WHERE P.name = 'Bob'
   ...>   )
   ...> );
Bob|Al
Bob|Doug
Bob|Gary
Chuck|Al
Chuck|Doug
Chuck|Ed
Chuck|Frank
Frank|Al
Frank|Chuck
Hamza|Doug
Hamza|Gary
Ibrahim|Al
Ibrahim|Gary