ntile

The ntile window function, translated to ntile(n) in SQL.

Divide a partition into n groups (buckets), assigns each row in the partition its bucket number, and return the bucket number of the current row within its partition. For example, if n is 4, ntile() divides rows into four buckets. If n is 100, ntile() divides rows into 100 buckets.