TSQL Query count with multiple columns

Question

I have a table that is structured like so:

Account, Tag
------------
123, dog
123, owl
456, pig
456, goat
678, dog
789, owl

I need to create a statement that will return the following data:

Tag name with the total number of account it's on:

Dog 2
owl 2
pig 1
goat 1

Answer 1

select Tag, count(*)
from table
group by Tag