I managed to come up with a solution to my own problem. I'll post it anyhow, maibe somebody else could use it:

SELECT a.Payer_ID, Count(a.Transaction_type) AS Volume, Sum(a.Amount) AS Value,...