Netflix's growth team wants to change what new users see first. Before they do, they ask you: does the genre of a user's very first title say anything about whether they come back?
For each user, take their first watch session (earliest start_ts, then the smaller session_id) and the first genre listed in that title's genres (the part before the first ;). A user is retained if they have another session on any of the 7 days after the day of that first session.
For each first genre with at least 20 users, show the number of users and the percentage retained.
Expected output
retained_pct as a percentage rounded to 1 decimal; any row orderExample of the shape (made-up values):
| first_genre | users | retained_pct |
|---|---|---|
| Mystery | 64 | 51.6 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.