You should be able to do so using a workflow though it may look a bit complex:Fetch all records from the tableDo a forkDo an Enrichment and join both parts of the forkIn the enrichment join the data using a N complexity join on Email + EventIn Additional data, add the result of the query and choose aggregatesHere you now can define Sum on the score columnThat should aggregate the data accordingly

You can't do so in ACS with a workflow unfortunately.Though you could solve it externaly by using the ACS API:Call to /rest/workflow/execution/byLogicalStatus?state=error to determine all failed workflowsSending a stop for the workflow, see https://docs.adobe.com/content/help/en/campaign-standard/using/working-with-apis/managing-workflows/controlling-a-workflow.html

No I've used a JS condition in my html directly in the delivery