I have a table many records



Name

Jonh
Jonh
Jonh
Jonh
Albert
Jonh
Jonh
Albert
Moses
Moses

I want to summarize it to a new table, the name would appear
only once and a new fiel counts how many times the name occours

Name ========= occours

Jonh ====== 6
Albert ====== 2
Moses ====== 2