I'm not an expert, and I'm certain there are more elegant ways of performing this task but one approach is to use a subquery to total the payments collected

SELECT a.[Invoice...