Lesson 13.3 · Pro
Writing SQL other people can read
A simple house style: one step per CTE, clear names, and a layout that's easy to check.
In this lesson
- One step per CTE, named for what it holds
- Prefer CTEs to nested subqueries
- Small habits that help
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.