blob: 6d7439866eeb3b00826a600fddd5f771d260f9b0 [file]
select mod(t.soa[0].`in`,10) soamod, avg(t.soa[1].fl) soaavg, count(t.soa[2].nul) soacount, count(distinct(t.soa[3].bool)) soadist from `complex.json` t group by mod(t.soa[0].`in`,10) order by mod(t.soa[0].`in`,10);