How to select an object within a collection?

Remove the LET and replace with actual LET expression and try it. Check this out Error evaluating filter. - cause: FROM in correlated subquery must have USE KEYS