Write POSTGRESS select statement, count and unique

I have a table that looks this:

ID | Record | Name | Category

1 12345 Juan Inf General

2 67897 Bill Sports

3 18787 Sandip Inf General

4 38799 Sandip Inf General

5 45791 Sandip Inf General

6 70787 Francis Inf General

7 90447 Allan Sports

8 11100 Aswan Gaming

I need a postgres (9.3) select statement that would return the "count" data like this:

Category | count

----------+-------

Inf General | 2

Sports | 2

Gaming | 1

Note above that the counter should only increment when the value for Name is unique...

One statement that gives the counts but gives the wrong data is this:

statement SELECT category, COUNT(*) FROM "table" GROUP BY category

this gives data like this:

Category | count

----------+-------

Inf General | 5

Sports | 2

Gaming | 1

PostgreSQL

Rif. progetto: #6869537

Info sul progetto