SQL-Style Questions: Joins with XLOOKUP, Unmatched Rows and GROUP BY with SUMIFS
This lesson is part of the course
In this lesson
You answer three SQL questions without SQL: a LEFT JOIN of orders to customers with a label for unmatched rows, a count of orders per customer including customers with none, and revenue per region.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Warm-Up: Clarifying the Question, Points vs Percent and Share-of-Total Traps Locked
- SQL-Style Questions: Joins with XLOOKUP, Unmatched Rows and GROUP BY with SUMIFS Locked
- Metric Definitions: Active Users, Conversion and Why the Denominator Decides Locked
- Distribution Questions: Mean vs Median vs p90 and the Effect of One Outlier Locked
- Quick A/B Read: Conversion per Variant, Lift in Points and "Is It Worth Shipping?" Locked
- Cohort Retention: Months Since Signup, the Cohort Grid and Pooled vs Average Rates Locked
- Sanity Checks: Duplicated Rows, Impossible Rates and Totals That Don't Add Up Locked
- Capstone: A Timed Take-Home – Net Revenue, Refund Rate, Revenue by Channel and One Chart Locked