How can we avoid counting duplicate values in a column?

By using COUNT together with DISTINCTBy using only COUNT, since it ignores duplicates

By using COUNT together with DISTINCT.