framework/resources/Functional/complex/json/complex55.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;