For related scenarios, see: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.