DISTINCT comes before the column's name because we're getting the distinct values, and then counting them.

Make sure to pick COUNT, followed by DISTINCT.