This guide explains how to organize complex SQL queries with multiple subqueries using Common Table Expressions (CTEs). You can use CTEs to organize the individual subqueries as logical building blocks of the main query. The resulting code is more readable, better organized, and can be reused in different places throughout the query. A CTE starts with the keyword `WITH`. Because of their syntax, CTEs are sometimes known as *WITH queries*. In its simplest form, a CTE looks like this: --......