Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
complex
/
json
/
complex56.q
blob: 9a14343f0d7ffb7e88d9890caee176fd691902fc [
file
] [
log
] [
blame
]
select
t
.
gbyt
,
count
(
t
.
id
),
max
(
t
.
id
),
min
(
t
.
id
),
avg
(
t
.
id
)
from
`complex.json`
t
where
t
.
nul
is
null
group
by
t
.
gbyt order
by
t
.
gbyt
;