Windowed aggregates: aggregate over constants; unbounded preceding; primitive scalars.