Customer Segmentation in SQL With CASE WHEN

Aggregate to one row per customer, label with CASE, group by the label. The order that deletes a whole segment, the gap that creates a NULL one, and fixed cut-offs against NTILE.