A query joins two tables with multiple matching rows per key and unexpectedly multiplies the sales total. Which approach best fits?

1. Use COUNT DISTINCT on the stable customer identifier.
2. Use SAFE_DIVIDE and handle its result explicitly.
3. Validate join cardinality and aggregate or deduplicate at the intended grain.
4. Join results to a complete calendar dimension and fill only the intended missing measures.