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

select t.gbyi, count(t.id), max(t.id), min(t.id), avg(t.id) from `complex.json` t where t.gbyi <= 5 or t.gbyi >= 11 and t.gbyt <> 'ooof' group by t.gbyi order by t.gbyi;