SQL join integrity — synthetic
Simone Santia
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.
Like this project
Posted Oct 12, 2026
SQL join integrity — synthetic demonstration. A SQLite exercise preserves 4 source deals and the 45,000-cent total while a naive association join inflates th...
Likes
0
Views
2
