When counting by column, we can use DISTINCT to avoid counting duplicates.
DISTINCT
Make sure to type DISTINCT.