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

select t.gbyt, count(t.id), max(t.id), min(t.id), avg(t.id) from `complex.json` t where t.bool is true group by t.gbyt order by t.gbyt;