Sign in
apache
/
drill-test-framework
/
refs/heads/main
/
.
/
framework
/
resources
/
Functional
/
complex
/
json
/
complex212.q
blob: 41f1784d14434225d4b11cde6cbd6bd8ddda29ce [
file
]
select
t
.
gbyi
,
max
(
t
.
ooof
.
oa
.
oab
.
oabc
)
maxooof
from
`complex.json`
t
group
by
t
.
gbyi having max
(
t
.
ooof
.
oa
.
oab
.
oabc
)
>=
99988
order
by
maxooof
;