• Is it possible that they have multiple per one day? You are counting distinct days. Why not just do COUNT(*).

    What duplicates are you trying to rid yourself of?