Multi-Step Funnel Analysis With CTEs

Hard
ctes Meta Airbnb Netflix

Analyze a signup funnel: count users at each stage (visited, signed_up, purchased). Use CTEs to compute each stage count and return stage and user_count in funnel order.

Expected Output: Three rows showing funnel drop-off.

Tables

Hints (3 available)

SQL Editor

Output

Click "Run" to see results...