Orders and Customers are joined on CustomerID. Customers contains duplicate IDs. What should the engineer check before summing revenue?

Published
  1. Only whether customer names are uppercase
  2. Whether the output has more columns than input
  3. Whether the join multiplies order rows
  4. Assume every join preserves the left row count

Comments — 0