blob: 449f9f0b71ff065b404e69b4eef1e63b826162aa [file] [log] [blame]
select mod(trunc(t.ooof.oa.oab.oabc),10) ooofmod, avg(t.ooof.oa.oab.oabc) ooofavg from `complex.json` t group by mod(trunc(t.ooof.oa.oab.oabc),10) order by mod(trunc(t.ooof.oa.oab.oabc),10);