Common Table Expressions Step by Step

A compact CTE book for readers who need exact finite non-recursive common-table-expression behavior: base tables, one named CTE output table, body references, joins against a CTE, duplicate-name and missing-reference rejection, recursive/materialized claims out of scope, and guarded expected facts.