SELECT * FROM Scale ( ON scale_housing AS INPUT PARTITION BY ANY ON (SELECT * FROM ScaleMap ( ON scale_housing InputColumns ('[2:6]') ) ) AS statistic DIMENSION Method ('midrange', 'mean', 'maxabs', 'range') Accumulate ('id') ) ORDER BY 1,7;
SELECT * FROM Scale ( ON scale_housing AS INPUT PARTITION BY ANY ON (SELECT * FROM ScaleMap ( ON scale_housing InputColumns ('[2:6]') ) ) AS statistic DIMENSION Method ('midrange', 'mean', 'maxabs', 'range') Accumulate ('id') ) ORDER BY 1,7;