Cohort analysis grouping by onboarding quarter
I want a cohort view of vendor onboardings. Group vendors by the quarter they were onboarded (`onboarded_date`). Columns: `cohort_year`, `cohort_quarter`, `vendor_count`. Sort chronologically.
Each hint you reveal reduces the XP you can earn. Try the query first.
EXTRACT(YEAR FROM onboarded_date::date), EXTRACT(QUARTER FROM onboarded_date::date).
COUNT(*) per cohort. GROUP BY both year and quarter.
ORDER BY cohort_year, cohort_quarter.