Can you explain the difference between Multi-Org and Single Org approaches in Salesforce and the tradeoffs?
Using the provided Salesforce-style org and account tables, write a SQL query that quantifies the two approaches for comparison.
architecture, org_count, account_count, unique_customer_count, missing_customer_key_count, duplicate_account_count, and avg_accounts_per_orgduplicate_account_count counts repeated non-null customer keys within each architecture| Column | Type | Description |
|---|---|---|
| org_idPK | INT | Unique Salesforce org identifier |
| deployment_id | VARCHAR(20) | Deployment grouping identifier |
| architecture | VARCHAR(20) | Org architecture, Multi-Org or Single Org |
| region | VARCHAR(30) | Primary operating region |
| status | VARCHAR(20) | Org lifecycle status |
| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique account record identifier |
| org_id | INT | Salesforce org containing the account |
| customer_key | VARCHAR(30) | Enterprise customer identifier used to detect duplicates |
| account_name | VARCHAR(100) | Salesforce account name |