Cohort Retention Analysis

Problem

You are defining user cohorts based on their signup month. Write a query that outputs concept with the value: "Cohort analysis groups customers by their first transaction date and tracks their behavior over time."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution