This is the Sprint-1 stub for ai.careerplane.data-analytics.data-engineer.sql.ctes-subqueries.
The fully-generated topic page (sandbox + quiz + AI hints + interactive
tooling) lands in Sprint-2 at
static/content/data-analytics/Data Engineer/SQL/CTEs & Recursive Queries — WITH Clause / Hierarchies / Graph Walks/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
Data Engineer career path.
sqlcterecursivewithhierarchygraph
You should already know
Window Functions — ROW_NUMBER / RANK / LAG / LEAD / SUM OVER
Next up
PIVOT / UNPIVOT & Conditional Aggregates for Reporting