Need a hand with a simple query

Question

I need a help with a query. I think is not so difficult.

I need to do a select with distinct and at the same time, do a count(*) of how many rows are returned by this distinct.

One example:

Table names>
Id   Name
1    john
2    john
3    mary

I need a query thats return:

Name    Total
john    2
mary    1

Answer 1

SELECT name, count(*) as occurrences FROM names GROUP BY name

Answer 2

SELECT name, COUNT(*) FROM names GROUP BY name

Answer 3

select name, count(*) from names group by name;