Advanced SQLWindow functions, CTEs, subqueries, recursive queries, lateral joins, pivot/unpivot, and advanced SQL patterns.