Weather Observation Station 4

  • Asked to answer
    + 1 comment

    Why are you doing count id < 2?

    You need the count of all cities, regardless of their ID, minus the number of distinct cities. The number of duplicate cities is 13, so it looks like your query is off by 1.