CTEs allow us to create temporary tables in SQL. And use them as sort of variables in other queries. Turns out this is one of the most important patterns to make your life easier when doing complicated queries. SyntaxWITH name_of_cte ( column1, column2,