for all

Works with summary expressions to define the scope to be all the specified grouping columns in the query. See also the for clause.

aggregate_function ( expression for ALL expression { , expression } )