for

Works with summary expressions to define the scope of the aggregation in the query.

Syntax

aggregate_function ( expression for expression { , expression } )