SQL Cohort Performance Over Time | Dataford Interview Questions

How do you write a query to identify top-performing customer cohorts over a 6-month period?

Calculate cohort performance for customers who signed up from January through June 2024, using completed Bolt rides during the same period.

Output

One row per signup-month cohort, including cohorts with no completed rides.
Columns: cohort_month, cohort_customers, completed_rides, total_revenue, and performance_rank.
Order by performance_rank ascending, then cohort_month ascending. Ties should share the same rank.

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name
signup_date	DATE	Date the customer joined Bolt
email	VARCHAR(255)	Customer email address

rides

Your question is SQL Cohort Performance Over Time. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

How do you write a query to identify top-performing customer cohorts over a 6-month period?

Calculate cohort performance for customers who signed up from January through June 2024, using completed Bolt rides during the same period.

One row per signup-month cohort, including cohorts with no completed rides.
Columns: cohort_month, cohort_customers, completed_rides, total_revenue, and performance_rank.
Order by performance_rank ascending, then cohort_month ascending. Ties should share the same rank.

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name
signup_date	DATE	Date the customer joined Bolt
email	VARCHAR(255)	Customer email address

rides

Your question is SQL Cohort Performance Over Time. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.