Potresti provare con SUM().

SELECT *, SUM(A) AS a,
SUM(B) AS b,
SUM(C) AS c
....
FROM table
WHERE A = 3
GROUP BY a