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')
) ORDER BY id;