adding rows! is it possible?

[Sakib Farid]

hi,

i have a little problem, dont know if u can do this

say we have the following table


ANIMAL NUMBER
dogs 3
dogs 2
dogs 1
cats 2
cats 5
bats 1

select * from pets produces this result

can i now do a query which will give me the following results by adding the number rows together where the animal is the same

ANIMAL NUMBER
dogs 6
cats 7
bats 1

or even

NUMBER
6
7
1

pls help!!!!!!!