Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
complex
/
json
/
complex206.q
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
;