COUNT   applies to duplicates, unless otherwise stated:

SELECT  Count(category)          same as Count(*)

FROM     Product

WHERE   year > 1995

Better:

SELECT  Count(DISTINCT category)

FROM     Product

WHERE   year > 1995