blob: 4754d16798f3c0d8dec2faf5b18565bcf38da08e [file]
select mod(t.ooa[0].`in`,10) ooamod, count(t.id) countid from `complex.json` t group by mod(t.ooa[0].`in`,10) order by mod(t.ooa[0].`in`,10);