SELECT * FROM WMAVG ( ON stock_vol PARTITION BY id ORDER BY name TargetColumns ('stockprice', 'volume') WindowSize ('5') IncludeFirst ('true') ) ORDER BY id, period;
SELECT * FROM WMAVG ( ON stock_vol PARTITION BY id ORDER BY name TargetColumns ('stockprice', 'volume') WindowSize ('5') IncludeFirst ('true') ) ORDER BY id, period;