sql/src/test/resources/drill/window/queries/nestedAggs/frmclause12.q

SELECT 
    AVG(SUM(c3)) OVER(PARTITION BY c8 ORDER BY c1 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW), 
    c8 
FROM "t_alltype.parquet" 
GROUP BY c1,c8