Why Did My Totals Double?

Talk it through with a coach who asks guiding questions and gives hints until you reach the answer. Pass to mark the challenge as completed.

The problem

  • medium
  • Pro

A report joins orders to both their line items and their payments, then sums the order totals, and the revenue comes out far too high. Explain why joining to two one-to-many tables multiplies rows, and how you'd fix the report.

Talk this problem through with an AI coach

This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.

Start free →