Scenario SQL Question

Customer Lifetime Value (CLV) by Cohort

Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.

Problem Statement

For each signup-month cohort, compute the number of customers, total revenue, and average CLV (revenue per customer). Return cohort_month, number_of_customers, total_cohort_revenue, average_clv — ordered by cohort_month.

Relevant Tables

orders

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

Date & Time FunctionsSQL Fundamentals
Range & Interval FilteringAdvanced Filtering
NULL HandlingSQL Fundamentals