Unsupported subquery expression:
Accessing outer query column is not allowed in this location`<treeNode>`.
Found an aggregate function in a correlated predicate that has both outer and local references, which is not supported:
Lateral join condition cannot be non-deterministic:
Non-deterministic lateral subqueries are not supported when joining with outer relations that produce more than one row`<treeNode>`.