Lesson 5.5 · Pro
Join fan-out: when totals come out too big
Joining two one-to-many tables copies rows and inflates sums. Aggregate first, then join.
In this lesson
- See the problem
- Fix it: aggregate each table first
- Check row counts as you go
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.