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

select t.gbyi, count(t.id), max(t.id), min(t.id), avg(t.id) from `complex.json` t where t.nul is not null group by t.gbyi order by t.gbyi;