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