CareerPlane topic · v1

Window Functions — ROW_NUMBER / RANK / LAG / LEAD / SUM OVER

Mid Professional priority 1 Sandbox & Interactive Quiz
This is the Sprint-1 stub for ai.careerplane.marketing-sales.growth-marketer.sql.window-functions. The fully-generated topic page (sandbox + quiz + AI hints + interactive tooling) lands in Sprint-2 at static/content/marketing-sales/Growth Marketer/SQL/Window Functions — ROW_NUMBER / RANK / LAG / LEAD / SUM OVER/index.html (per arch/memo.md → D-2026-04-22-13). The //go:embed all:static directive auto-serves it on the next container rebuild — no server-code change needed.

What this topic teaches

SQL skills for the Growth Marketer career path.

sqlwindow-functionsrow_numberranklagleadpartition

You should already know

GROUP BY & HAVING — Aggregations, Filters on Aggregates

Next up

CTEs & Recursive Queries — WITH Clause / Hierarchies / Graph Walks

Help CareerPlane grow