Netflix wants to identify which titles most effectively drive completed new memberships. Analyze activity from Q2 2025, using only viewers whose recorded event was their first-ever view of that title.
Write a PostgreSQL query to return the top ten titles by new-signup completion rate.
Requirements
- Include first-time title viewers whose viewing occurred from
2025-04-01 through 2025-06-30.
- Join signup attempts attributed to the same title and viewer, retaining viewers without a signup attempt.
- Calculate completion rate as completed signup attempts divided by first-time viewers. Return the top ten titles, ordered by rate descending, then viewer count descending, then title name ascending.
