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

Write a query to calculate customer lifetime value grouped by signup cohort (month). Return cohort_month, number_of_customers, total_cohort_revenue, and average_clv.

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