A reporting engineer has copied the customer dimensions to practice.accounts. This copy belongs to your current exercise, so each task starts from the same source snapshot. Apply only the requested change. The checker reads the table afterward, including rows you should have left alone.
The payment tasks use the original raw webhook table. Its payload holds JSON text, and some paths are absent on subscription-deletion events. Read scalar values with JSON_VALUE, cast numbers before arithmetic, and filter the event type before combining amounts. Each task is independent. A statement that runs successfully can still update the wrong accounts or count the wrong events, so verify the business rule as well as the SQL syntax.