Did you know ... Search Documentation:
CQL: INNER JOIN with an aggregation sub-query where the sub-query is constrained by a shared variable from the main query