Cohort Analysis Using Pure SQL

Runnable queries from the article, translated to the SQLite dialect and executed by a real SQLite engine (sql.js/WebAssembly) in your browser. The article's exact sample data — 7 users, 12 orders — is preloaded and rebuilt fresh before every run, so feel free to INSERT, UPDATE, or break things.