Integer Input - Aster Analytics

Version 1.0

SELECT * FROM DistnmatchReduce (
  ON DistnmatchMultipleInput (
    ON (SELECT COUNT(1) AS counts,
      SUM(COUNT(1)) OVER (PARTITION BY  column [,...]
      ORDER BY  column_name) AS rank,
      column [,...],  column_name 
      FROM  input_table 
      WHERE  column_name  IS NOT NULL
      GROUP BY  column [,...],  column_name 
    ) AS input PARTITION BY ANY
    ON (SELECT  column [,...],
      COUNT(*) AS group_size,
      AVG (column_name) AS mean,
      STDDEV (column_name) AS sd,
      MAX (column_name) AS maximum,
      MIN (column_name) AS minimum
      FROM  input_table 
      WHERE  column_name  IS NOT NULL
      GROUP BY  column [,...]
    ) AS groupstats DIMENSION
    ValueColumn (column_name)
    [ Tests ('test' [,...]) ]
    [ Distributions ('distribution1:parameter1' [ ,... ]) ]
    [ GroupByColumns
    ({ 'group_by_column' | 'group_by_column_range' }[,...]) ]
    MinGroupSize (minGroupSize)
    [ NumCell (cellSize) ]
  )
  PARTITION BY  column [,...]
  [ Top ('top') ]
);