[MYSQL] Select quasi impossibile

[fcaldera]

modificarla così?

SELECT codicefiscale, SUM(num1) as sum1, SUM(num2) as sum2, SUM(num3) as sum3,
(SUM(num1) + SUM(num2) + SUM(num3)) as totale
FROM tuatabella
GROUP BY codicefiscale