blob: 286f176247283393195aac3f4b051a7c9a81b62b [file] [log] [blame]
select t.gbyi, avg(t.sia[0]) avgsia from `complex.json` t group by t.gbyi having avg(t.sia[0]) < 499189 order by avgsia;