Supercell's monetisation team wants to know what players buy first, and how long after installing the game.
For each player who made a purchase, show the item of their first purchase (earliest purchase_ts, then the smaller purchase_id) and the number of days between install_date and that purchase's date.
Expected output
Example of the shape (made-up values):
| player_id | first_item | days_to_first_purchase |
|---|---|---|
| 77 | Gem Pack S | 4 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.