Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
nestedAggs
/
wPbOb_5.q
blob: 848611695889ab0e0cc5902a6a6918a1d932393b [
file
]
SELECT c2
,
AVG
(
AVG
(
c1
))
OVER
(
PARTITION BY c2 ORDER BY c2
)
FROM
`tblWnulls.parquet`
GROUP BY c2
;