hardShopee · windowPro
Split customers into spending quartiles
Marketing wants customers split into 4 equal-sized spending quartiles, where 1 is the lowest-spending group and 4 is the highest-spending group.
Return customer, total_spend, and quartile.
Schema
▸customer_spend
| customer | TEXT |
| total_spend | NUMERIC |
Pro
The example input, expected output, and walkthrough for this question unlock with a Pro plan.
Pro
This is a Pro question
Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.