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