Lesson 4.1 · Pro
WITH: build a query one step at a time
Name each step of a query with a CTE so it's easy to read, check and change.
In this lesson
- Name a step with WITH
- Chain several steps
- Turn a nested query into CTEs
- When a short IN (SELECT ...) is fine
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.