For related scenarios, see:Scenario: Mapping data using a simple implicit join.Scenario 1: Aggregating table columns and filtering.Scenario 2: ELT using an Alias table.A related scenario using subquery: Scenario: Mapping data using a subquery.