ID  |   Name  |  Dog    |   Cat   |
===================================
1   | A       |   100   |   0     |
1   | B       |   0     |   100   |
1   | C       |   50    |   0     |
2   | A       |   100   |   0     |
2   | B       |   3     |   100   |
2   | C       |   3     |   50    |

ID  |   Name  |  Dog    |   Cat   |
===================================
1   | A       |   100   |   0     |
1   | B       |   0     |   100   |
1   | C       |   50    |   0     |
1   | TOTAL   |   50    |   0     |
2   | A       |   100   |   0     |
2   | B       |   0     |   100   |
2   | C       |   0     |   50    |
2   | TOTAL   |   0     |   -50   |

SELECT ID, Name, SUM(Dog), Sum(Cat)
FROM Table
GROUP BY ID

ID  |   Name  |  Sum(Dog)|   Sum(Cat)|
======================================
1   | C       |   150    |   100     |
2   | C       |   100    |   150     |