TPC-H QUERY 15 - SCALAR CONSTANTS AND MATERIALISATION

Summary from the TLDR Data newsletter

Referencing the same CTE twice tests whether the optimiser materialises the result.