Pretty often SQL is used to calculate different metrics or to aggregate values and measurements. Alongside with aggregating functions there are windows functions, which are used widely.