D8LooPFocus modeCODE WORKSPACE
Load reconciliation summary
Produce insert, update, delete, and unchanged counts for a load audit report.
The SQL API will hydrate this workspace with the exercise-specific starter query and schema.
Sample input
action planAfter dedupe and comparison, count each action as the load receipt.
| customer_id | load_action |
|---|---|
| 101 | update |
| 102 | insert |
| 103 | delete |
| 104 | update |
| 105 | unchanged |
| 106 | insert |
Expected output
Expected outputThese counts are the audit receipt: 2 inserts, 2 updates, 1 delete, and 1 unchanged row.
| load_action | rows |
|---|---|
| delete | 1 |
| insert | 2 |
| unchanged | 1 |
| update | 2 |
Constraints
Load the live SQL exercise to inspect the full prompt, schema, starter query, and expected output.
Expected skills
Reconciliation, Auditing, Counts
SQL
Loading...
AI evaluation
Run the SQL query to inspect preview rows.