codice:
select name,sum(numberA) as totA,sum(numberB) as totB,sum(numberC) as totC 
from tabella
group by name