Scenario SQL Question
Cohort Analysis - Customer Retention by Signup Month
Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.
Problem Statement
Write a query to perform cohort analysis by calculating customer retention. Return cohort_month, months_since_signup, active_customers, cohort_size, and retention_rate.
Relevant Tables
orders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: