SQL sandbox · runs in your browser

Query the SaaS Subscriptions & Churn dataset with SQL

Write SQL against the real tables without downloading or installing anything. Pick a starter query or write your own; nothing you run leaves your browser.

Answer 5 graded questions Download the full dataset →

Starter queries

Loading the SQL engine and dataset sample…

saas-subscriptions.sql⌘/Ctrl + Enter

Loading editor…

Ctrl/⌘ + Enter runs the query. Results show up to 200 rows.

Tables

5 tables

plans4 cols

plan_idTEXT PRIMARY KEY
plan_nameTEXT NOT NULL
monthly_priceREAL NOT NULL
included_seatsINTEGER NOT NULL

accounts5 cols

account_idTEXT PRIMARY KEY
created_atTEXT NOT NULL
regionTEXT NOT NULL
segmentTEXT NOT NULL
acquisition_channelTEXT NOT NULL

subscriptions8 cols

subscription_idTEXT PRIMARY KEY
account_idTEXT NOT NULL
plan_idTEXT NOT NULL
started_atTEXT NOT NULL
ended_atTEXT
statusTEXT NOT NULL
seatsINTEGER NOT NULL
mrrREAL NOT NULL

invoices6 cols

invoice_idTEXT PRIMARY KEY
subscription_idTEXT NOT NULL
invoice_dateTEXT NOT NULL
due_dateTEXT NOT NULL
amount_dueREAL NOT NULL
invoice_statusTEXT NOT NULL

payments5 cols

payment_idTEXT PRIMARY KEY
invoice_idTEXT NOT NULL
attempted_atTEXT NOT NULL
payment_statusTEXT NOT NULL
amountREAL NOT NULL

A linked sample of the full release

Every Nth customer, account, or product is kept with all of its related rows, so joins work and keys match. Totals are smaller than in the download.

plans4
accounts200 of 5,000
subscriptions200 of 5,000
invoices3,367 of 85,448
payments3,429 of 87,287