blob: 9e1cc1090740916095c5b1755916d68a0d30256d [file] [log] [blame]
select t.gbyi, max(t.sfa[1]) maxsfa from `complex.json` t group by t.gbyi having max(t.sfa[1]) > 10000 order by maxsfa;