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;