This article has not been completed yet. However, it may already contain helpful information and therefore it has been published at this stage.

SELECT followers.name FROM c
join followers in c.followers
where followers.name = "sam"