Top Customer Cohorts by Revenue | Dataford Interview Questions

Task

You are given a table of customer activity from PNC digital marketing campaigns. Write a SQL query to identify the top-performing customer cohorts, where a cohort is defined by cohort_month. Return each cohort's total revenue and customer count, sorted from highest total revenue to lowest, and show only the top 3 cohorts.

Because this is an easy SQL exercise, solve it using only a single table with aggregation, sorting, and limiting.

Problem

Task

Because this is an easy SQL exercise, solve it using only a single table with aggregation, sorting, and limiting.

Problem

Task

Because this is an easy SQL exercise, solve it using only a single table with aggregation, sorting, and limiting.

Problem

Task

Because this is an easy SQL exercise, solve it using only a single table with aggregation, sorting, and limiting.