#07 · SQL and analytics · 5.9 minSQL Window Functions and CTEs in DuckDB: Two Mistakes
Learn CTEs and window functions with DuckDB on a tiny orders table, then see two common mistakes, with real output.
Python 3.12.15 | duckdb==2.0.03 videos tagged "sql window functions".
#07 · SQL and analytics · 5.9 minLearn CTEs and window functions with DuckDB on a tiny orders table, then see two common mistakes, with real output.
Python 3.12.15 | duckdb==2.0.0
#124 · SQL and analytics · 6.6 minA 20-line SQL query builds a cohort retention table; remove DISTINCT and retention shows 150 percent.
Python 3.12.15
#134 · SQL and analytics · 6.4 minTwo missing days made SQLite report 156.6 in sales a day for a week that averaged 111.9 once the gaps were filled.
Python 3.12.15