This is the Sprint-1 stub for ai.careerplane.finance.financial-analyst-fpa.sql.ctes-subqueries.
The fully-generated topic page (sandbox + quiz + AI hints + interactive
tooling) lands in Sprint-2 at
static/content/finance/Financial Analyst (FP&A)/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
Financial Analyst (FP&A) career path.
sqlcterecursivewithhierarchygraph
You should already know
Window Functions — ROW_NUMBER / RANK / LAG / LEAD / SUM OVER
Next up
PIVOT / UNPIVOT & Conditional Aggregates for Reporting