Hugo, thanks for the very lengthy and detailed explanation. I already figured out how it worked, but I found the original explanation "there isn't a WHERE clause" a bit lacking. There is a WHERE clause in the query, but in the correlated subquery, not in the outer query.

Anyhow, thanks again for your detailed explanation 🙂