blob: fe44e0685c969574102bd67aa85d9a97fd68e82e [file] [log] [blame]
select mod(t.oooi.oa.oab.oabc,10) oooimod, avg(t.oooi.oa.oab.oabc) oooiavg from `complex.json` t group by mod(t.oooi.oa.oab.oabc,10) order by mod(t.oooi.oa.oab.oabc,10);