Supercell's monetisation team groups players by how much they've spent, using the usual game-industry names. They want the size of each group, including players who never paid.
Work out each player's total spend (revenue_usd in purchases), then count players per segment: 'non-payer' (no spend), 'minnow' (under 10), 'dolphin' (10 to under 50) and 'whale' (50 or more).
Expected output
Example of the shape (made-up values):
| segment | players |
|---|---|
| non-payer | 300 |
| whale | 4 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.