Window functions, CTEs, query optimization
Master recursive Common Table Expressions to query tree structures.
