dynamic subqueries - macro predicates, updated
dynamic subqueries - DistinctCountAgg