framework/resources/Functional/complex/json/complex278.q

select tt.gbyi, sum(tt.id), sum(tt.sia[1]) from (select t.id, t.gbyi, t.sia sia from `complex.json` t) tt group by tt.gbyi order by tt.gbyi;