Lesson 4.3 · Pro
Several metrics in one row
Calculate each number in its own small CTE, then line them up in a single summary row.
In this lesson
- One CTE per number, then cross join
- Do math across the CTEs
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.