Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
negative
/
q23.sql
blob: dfd8c84e9b33a7cf4f70c9019f8265d501fc4e04 [
file
] [
log
] [
blame
]
-- DRILL-3211 (requires group by)
select
avg
(
a1
),
sum
(
a1
)
over
(
partition
by
b1
)
from
t1
group
by
b1
;