SQL join integrity — synthetic demonstration. A SQLite exercise preserves 4 source deals and the 45,000-cent total while a naive association join inflates the sum to 80,000 cents. Ambiguous primary links, missing references and a null amount are surfaced. Equal-value legitimate deals remain distinct; reruns produce identical output. This is a local technical exercise, with no customer data or live HubSpot connection.