Step 2: Scale Test Data - Aster Analytics

SELECT * FROM Scale (
  ON scale_housing_test AS INPUT PARTITION BY ANY
  ON scale_stat AS STATISTIC DIMENSION
  Method ('midrange')
  Accumulate ('id')
);