Why Your JOIN Doubled Your Totals — There's No Error, Just the Wrong Number

Adapted from the SQL Essentials Companion Guide. You write a query to total up each customer's orders, and it runs fine — no error, no red text, just a result set: SELECT customers.name, SUM(orders.a