Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
complex
/
json
/
complex101.q
blob: b5d37116be6ba43e34f478e3bf8d39c5fa157cdf [
file
] [
log
] [
blame
]
select
t
.
gbyi
,
max
(
t
.
fl
),
min
(
t
.
fl
),
avg
(
t
.
fl
),
count
(
t
.
str
)
from
`complex.json`
t
where
t
.
bool
is
false
and
t
.
fl
<
1000
group
by
t
.
gbyi order
by
min
(
t
.
fl
);
