Google BigQuery: join e subquery

Sei qui: