Did you know ... Search Documentation:
CQL: INNER JOIN in an aggregation sub-query