Netflix's recommendations rely on ratings. The team wants to know where viewers watch but never rate, to decide where to show "rate this title" prompts.
For each user country, count users who have watched at least one title, and the percentage of those who have never rated anything.
Expected output
never_rated_pct rounded to 1 decimal; any row orderExample of the shape (made-up values):
| country | watchers | never_rated_pct |
|---|---|---|
| Canada | 12 | 41.7 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.