Cita: *******************************************
GROUP BY More Than One Column
We can also use the GROUP BY statement on more than one column, like this:
SELECT Customer,OrderDate,SUM(OrderPrice) FROM Orders
GROUP BY Customer,OrderDate
*******************************************
Si te fijas, el campo que pretendes sumar, no se agrupa.