DistributionMatchReduce version 1.6, DistributionMatchMultiInput version 1.3
SELECT * FROM DistributionMatchReduce (
ON DistributionMatchMultiInput (
ON (SELECT COUNT(1) AS counts,
SUM(COUNT(1)) OVER (PARTITION BY column [,...]
ORDER BY column) AS rank, column [,...]
FROM input_table
WHERE column IS NOT NULL
GROUP BY column [,...]
) AS input PARTITION BY ANY
ON (SELECT column [,...], COUNT(*) AS group_size
FROM input_table
WHERE column IS NOT NULL
GROUP BY column [,...]
) AS groupstats DIMENSION
USING
ValueColumn ('value_column')
[ Tests ('test' [,...]) ]
Distributions ('distribution:parameters' [,...])
[ GroupByColumns ({ 'group_by_column' | group_by_column_range }[,...]) ]
[ MinGroupSize (min_group_size) ]
[ NumCell (cell_size) ]
) AS alias_1 PARTITION BY column [,...]
) AS alias_2;