SELECT * FROM Scale (
ON scale_housing AS INPUT PARTITION BY ANY
ON (SELECT * FROM ScaleMap (
ON scale_housing
InputColumns ('[2:6]')
MissValue ('omit')
)
) AS statistic DIMENSION
Method ('midrange')
Accumulate ('id')
Intercept ('-min')
Multiplier (1)
) ORDER BY id;