Common Table Expressions (CTE) Query hierarchical data with a recursive CTE Find all columns by name in+distinct subquery vs. exists Materialized CTEs