Supercell's game team is redesigning the tutorial. They want to know where new players drop out, and whether it's worse on one platform. Tutorial steps are event_name = 'tutorial' rows in events, in this order: tutorial_start, move_joystick, first_attack, use_special, first_win, pick_name, tutorial_complete.
Count the distinct players who reached each tutorial step, in tutorial order.
Expected output
Example of the shape (made-up values):
| step_name | players |
|---|---|
| tutorial_start | 390 |
| move_joystick | 350 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.