Cohort and Retention Analysis in SQL: A Step-by-Step Guide
Cohort retention analysis in SQL, step by step: define cohorts, write the retention matrix query, read the triangle, and choose N-day or bracket retention.
WRITING / NOTES FROM THE FORGE
SQL
2 articles tagged SQL.
SQL Window Functions Explained With Practical Examples
SQL window functions explained with runnable examples: ROW_NUMBER vs RANK, LAG and LEAD, running totals, moving averages, and the ROWS vs RANGE frame trap.