Find the Row count of each value

I have table like

Name
A
B
B
C
C
C
A
A
B
B

I need Query to return output like

Name         count
A             1
B             2
C             3
A             2
B             2

I tried with rank(),dense_Rank().but i am not able to get output