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