Version 1.0
SELECT * FROM DistnmatchReduce ( ON DistnmatchMultipleInput ( 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 ValueColumn (value_column) [ Tests ('test' [,...]) ] Distributions ('distribution:parameters' [,...]) [ GroupByColumns ({ 'group_by_column' | 'group_by_column_range' }[,...]) ] [ MinGroupSize (min_group_size) ] [ NumCell (cell_size) ] ) PARTITION BY column[,...] );