Version 1.6
SELECT * FROM ScaleByPartition ( ON { table | view | (query) } PARTITION BY partition_columns USING ScaleMethod ('method' [,…]) [ MissValue ({ 'KEEP' | 'OMIT' | 'ZERO' | 'LOCATION' })] TargetColumns ( { 'target_column' | target_column_range }[,...] ) [ GlobalScale ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ] [ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ] [ Multiplier (multiplier [,...]) ] [ Intercept (intercept [,...]) ] ) AS alias;