A join combines rows that meet its ON condition. An inner join keeps matches. A left join also preserves unmatched rows from the left side, filling columns from the missing side with NULL. Choose the table on the left to match the report's promised population.
One-to-many joins change row counts. An order with two item lines appears twice after joining items. Summing the order's amount at that point counts it twice. Aggregate each side to the required grain before combining totals, or query the appropriate table directly.
A WHERE condition on the optional side of a left join can remove the rows you meant to preserve. Put a match restriction in ON when unmatched customers must stay. Count the matched table's nonmissing key when you want zero for an unmatched customer; COUNT(*) counts its placeholder row.
Join the customer foreign key, not two unrelated primary keys.