CMAVG (version 1.2) - Aster Analytics

SELECT * FROM CMAVG (
  ON {  table_name|  view_name| (query) }
    PARTITION BY  partition_column 
    ORDER BY  order_by_column 
  [ TargetColumns ({ 'target_column' |  target_column_range  }[,...]) ]
);