Loading this exercise…

Calculate subscription cohort retention

#2 · 2 of 5Free sample

Instructions

Calculate subscription cohort retention

A SaaS team is measuring retention for accounts that started in January 2025. Find each account's latest subscription event on or before 2025-03-31. An account is retained when its latest event_type is not cancelled.

Return exactly three columns: cohort_size, retained_accounts, and retention_pct rounded to 2 decimals.

Loading the practice editor and dataset…

Sign up to unlock

The reference answer is one attempt away.

A free account records your attempt and then reveals the reference answer and the explanation for every exercise in the library.

Reference answer + explanation revealed after each attempt
Progress saved on the platform
1,598 graded exercises
Free forever — no credit card
The GPT tutor is part of the course, not the free tier

Create free account →Already a member? Log in →

All exercises in Free Dataset Analysis

ecommerce_orders

6 cols

order_idINTEGER PRIMARY KEY
customer_idINTEGER NOT NULL
order_dateTEXT NOT NULL
statusTEXT NOT NULL
gross_amountREAL NOT NULL
discount_amountREAL NOT NULL

ecommerce_refunds4 cols

refund_idINTEGER PRIMARY KEY
order_idINTEGER NOT NULL
refund_dateTEXT NOT NULL
refund_amountREAL NOT NULL

subscription_accounts2 cols

account_idINTEGER PRIMARY KEY
started_onTEXT NOT NULL

subscription_events5 cols

event_idINTEGER PRIMARY KEY
account_idINTEGER NOT NULL
event_dateTEXT NOT NULL
event_typeTEXT NOT NULL
plan_mrrREAL NOT NULL

campaign_imports6 cols

import_idINTEGER PRIMARY KEY
campaign_idTEXT
activity_dateTEXT NOT NULL
channelTEXT NOT NULL
spend_usdREAL NOT NULL
conversionsINTEGER NOT NULL

inventory_opening2 cols

product_idINTEGER PRIMARY KEY
opening_unitsINTEGER NOT NULL

inventory_movements5 cols

movement_idINTEGER PRIMARY KEY
product_idINTEGER NOT NULL
movement_dateTEXT NOT NULL
movement_typeTEXT NOT NULL
quantity_changeINTEGER NOT NULL

bike_hourly6 cols

observation_idINTEGER PRIMARY KEY
ride_dateTEXT NOT NULL
hourINTEGER NOT NULL
working_dayINTEGER NOT NULL
seasonTEXT NOT NULL
rentalsINTEGER NOT NULL

Tables

8 tables

ecommerce_orders6 cols

order_idINTEGER PRIMARY KEY
customer_idINTEGER NOT NULL
order_dateTEXT NOT NULL
statusTEXT NOT NULL
gross_amountREAL NOT NULL
discount_amountREAL NOT NULL