← Learn/Part 3 · Advanced queries and reports

Complex questions break down into simpler ones. Subqueries and CTEs (WITH) let you build an answer step by step and read it like a story. Here — subqueries in WHERE/SELECT/FROM, IN versus EXISTS, the NOT IN with NULL trap, correlated subqueries, CTEs, and recursion over a tree.