Lesson 13.2 · Pro
Debugging a wrong answer
Five quick checks that catch most wrong results, each with a broken query to fix.
In this lesson
- 1. Check row counts after each step
- 2. Check for whole-number division
- 3. Check the date boundaries
- 4. Check where outer-join filters sit
- 5. Check window frames
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.