Window Functions — ROW_NUMBER / RANK / LAG / LEAD / SUM OVER
MidCollegepriority 1Sandbox & Interactive Quiz
This is the Sprint-1 stub for ai.careerplane.k12-education.college-student-cs.sql.window-functions.
The fully-generated topic page (sandbox + quiz + AI hints + interactive
tooling) lands in Sprint-2 at
static/content/k12-education/College Student (CS Major)/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
College Student (CS Major) career path.
sqlwindow-functionsrow_numberranklagleadpartition
You should already know
GROUP BY & HAVING — Aggregations, Filters on Aggregates