Part -2 Capstone Project
SQL for Product Growth — Part 2User Behavior & Growth Analysis — Interactive Capstone
CAPSTONE TASK
SQL for Product Growth — Part 2
User Retention · Funnels & Conversion · Cohorts · Feature Usage & Engagement · Customer Journeys · A/B Testing
Core tables
users · sessions · events · orders · experiment_results
Intermediate SQL
COUNT · COUNT DISTINCT · SUM · DATE · GROUP BY · HAVING · WHERE · ORDER BY
Growth questions
Who returns? · Where do users drop off? · Which cohorts engage? · Which actions are common? · What paths do users take? · Which experiment variant performs better?
User Retention · Funnels & Conversion · Cohorts · Feature Usage & Engagement · Customer Journeys · A/B Testing
Core tables
users · sessions · events · orders · experiment_results
Intermediate SQL
COUNT · COUNT DISTINCT · SUM · DATE · GROUP BY · HAVING · WHERE · ORDER BY
Growth questions
Who returns? · Where do users drop off? · Which cohorts engage? · Which actions are common? · What paths do users take? · Which experiment variant performs better?
Hint 1 — Reasoning clue
A conceptual clue is available.
Hint 2 — More specific
A more specific clue is available.
Show Solution
script.sqlComplete the Product Growth SQL
OUTPUT
Run your SQL to check the product-growth analysis result.
✦ AI Tutor
