asterix-app/src/test/resources/AQLTS/queries-sql-like/nestedFor.aql

from $user in dataset('User')
from $mv in dataset('Movie')
where some $i in $user.interests satisfies $i.movie = $mv.movie
select { "name": $user.name, "movie": $mv.movie }