Lesson 4.2 · Pro
Put one total on every row
Compute a total once, then attach it to every row with CROSS JOIN to get percentages.
In this lesson
- Compute the total in its own CTE
- Attach it to every row with CROSS JOIN
- Same idea, different table
- Compare each row with the average
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.