Back to problems

Compute monthly signups, conversion, and YoY growth

Algorithm · Intuit · Medium

You work for a subscription business and have a single user-level table, company_users, with one row per customer: id (INT, primary key) — the customer identifier signup_date (DATE) — the UTC day on which the account was created subscription_date (DATE, nullable) — the UTC day that the customer's first subscription began; NULL when no subscription was ever started termination_date (DATE, nullable) — the UTC day that subscription ended; NULL while it is still running…

Checking your access…