Date-Based Cohort Analysis
Hard
date-functions
Amazon
Instacart
Robinhood
Write a query to group users by their signup month (cohort) and count how many users signed up in each cohort. Also calculate the total revenue generated by each cohort. Return cohort_month, user_count, and cohort_revenue, ordered by cohort_month.
Expected Output: Monthly signup cohorts with user count and total revenue.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...